Conditional format formula

[erniepoe]

Hi all,

I'm in Excel 2010, and I'm trying to format the color of certain cells based on the percentage value in the cell below it.

Anything 50% or greater is red
Anything 20% or greater is orange
Anything 20% or less is green
Anything 0% is yellow


I'm using the "use a formula to determine formatting" option, and it's all working except for the yellow, which are still showing up as green.


The rules I have are set as follows:

=ABS(G7)<(0.201) --> green
=ABS(G7)<(0.5) --> orange
=ABS(G7)=0 ---> yellow
=ABS(G7)>(0.5) ----> red


Not sure why the formula for yellow fill isn't being picked up. Do I need to make the green cell for values between 0 and .20? Is it possible to do that in the conditional formatting section?

Thanks for any help,
Ernie

 

[Andrew Poulsom]

It's because zero is less than 0.2. Put the zero condition first.