Excel: Conditional Formatting using 3 colours for percentage ranges.

Hi, I have searched but not able to find what I'm after. I am trying to return 3 different colours for percentage ranges in excel. I can get two colours to work - but not the 3rd. This is what I'm trying: IF$F$76>=95% (Green) IF$F$76>=85% (Yellow) IF$F$76<85% (Red) I can get Red and Green to work, or Red and Yellow, but not all 3. Anyone know what I'm doing wrong?

This question generated 9 answers. To proceed to the answers, click here.

This thread is current as of September 07, 2014.

For more resources for Microsoft Excel