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