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
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2