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?
Bookmarks