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 i...
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.
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.
