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

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

What happens to E10 if BOTH E67=4 AND F67=7?

Remember, formulas can only 'pull' data from other cells, not 'push'
data to other cells (you need VBA to do that). Therefore, you will
need to set your CF in each specific cell you want to change. e.g. in
E10:

Condition1: Formula Is: =$E$67=4 set format as Green Bold

I would set my normal format of this cell to White, as the only time
you don't want white is when E67=4

repeat as needed for cells F10, G11 and so on...

HTH

Bruce


--
swatsp0p


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