Conditional Formatting help (2003)

J

Jooniper

Hi all,

I am trying to apply conditional formatting to A1 where if B2 is greate
than or equal to 20 (green), if between 14 and 19 (amber) and if les
than or equal to 13 (red).

Any help greatly appreciated
Thank
 
C

Claus Busch

Hi Jooniper,

Am Thu, 27 Jun 2013 09:45:33 +0100 schrieb Jooniper:
I am trying to apply conditional formatting to A1 where if B2 is greater
than or equal to 20 (green), if between 14 and 19 (amber) and if less
than or equal to 13 (red).
Click to expand...

format A1 with red back color. Then select A1 => CF => use formula:
=B1>=20 for green
and
=B1>=14 for amber
The rule for green color has to be rule 1


Regards
Claus Busch
 
Top