Originally Posted by Claus Busch

Hi,

Am Mon, 5 May 2014 11:01:05 +0100 schrieb slipper:

IF(A1 <= 4) then (A2&&A3 = green, A4 = red)
IF(A1 4) then (A2 = green, A3 = red, A4 = orange)

The above is not exactly what i want just as way of an explanation, is
this possible at all? can't see a way of doing it with conditional
formatting, only of changing the colour in the cell with the value in
it.

look again in OneDrive for the workbook. I changed the code to the above
colors.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional