Forum Discussion
Solved
conditional formatting not applying
Can anyone see what's wrong here? the word silver should be grey, not red.
I do think I see what is wrong in your original. The 2nd, 3rd, and 4th values are comparing to 'percent', not 'number':
Thank you. Both solutions work.
I ignored the 'percent' selection as it was grayed out so didnt expect it to be doing anything.
However, changing the 'appy to' option to Values, not Values and Totals makes it available again.
I could then change it to 'number'.
Changing back to values and totals then worked and displayed the correct colour.