Forum Discussion
Solved
Problem with conditional formatting?
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.
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.
2 Replies
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.
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.
