Forum Discussion
Conditional Formatting Not Working
I am trying to use conditional formatting and it is not working properly. I need the cells that are 74 or below to show a red icon and 75 and above showing a green icon. I am still getting red icons ...
Hi lesliannd2,
Clear Rules for the above cells and Apply Correctly. I doing the same. It works fine.
The only difference is type is specified as Percent.
I've attached a sample file too.
See the image.
Thank you for your help. 73% should be red though not green.
Red 74 or below
Green 75 or above
Thats the issue I am having.