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?