Problem with conditional formatting?

[Walter Richards]

Hi,

I am having a difficult time trying to figure out what is wrong with conditional formatting.

I want it to be: green over 95%, yellow 85% to 94.99%, and red below 85%.

However, the highlights in the attached picture show it's not working as intended.

[#2 · Accepted solution]

Try setting the Type to Number rather than Percent and then using 0.95 and 0.85:

You can reference the attached Excel Workbook for an example.

[#3]

Thanks, Matt

That worked!

Even though the original data is percentages, Excel must covert it to a number when I copy and paste (value) it to this worksheet.