Is it possible to have nested conditions using Conditional Formatting?
I have a range of columns that change colour according to their
totals.
Here is the Psuedo code.
If E67 = 4 Then E10 Font = GREEN BOLD, F10 = RED BOLD
Else E10= WHITE(invisible), E11 = WHITE(invisible),
If F67 = 7 Then E10 Font = WhiteF10 = GREEN BOLD, G11 = RED
BOLD........
and so on.......
Basically the first Column Header Font goes From white to Green , the
next column header font goes red, then when that one changes green the
next one goes red etc etc.
If this makes sense to anyone, can it be done?


--
ANDYPAND
------------------------------------------------------------------------
ANDYPAND's Profile: http://www.excelforum.com/member.php...o&userid=25351
View this thread: http://www.excelforum.com/showthread...hreadid=392191