Conditional Formating with 3 % ranges

[mack314]

Hello-

Running excel 2007. I need to color 8 cells E161:H162 a color based on the percentage value in each of the 8 cells

The conditions are as follows:


GREEN >= 99%
YELLOW: < 99% and >=97%
RED: <=96.99%


I've messed around with it but can't seem to figure it out. Thanks!

 

[abmati]

Select the range E161:H162,
click Home-->Conditional Formating->New Rule.
Then select Formal only cells that contain->Cell Value -> greater than or equal to -> .99 -> Format -> Fill -> Select Green color -> OK ->OK
Repeat the same for Yellow color, here Cell Value -> between -> 0.97 and -> 0.9899
for red color Cell Value -> less than or equal to -> 0.9699

 

[mack314]

Thank you abmati!

I think the part that was confusing me was that I had to go back into conditional formating for each range. Your suggestion worked perfectly.