Nested Ifs In Conditonal Formats

[ANDYPAND]

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?

[swatsp0p]

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