Conditional Formatting help (2003)

[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

 

[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).

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