Nested Ifs In Conditonal Formats

  • Thread starter Thread starter ANDYPAND
  • Start date Start date
A

ANDYPAND

Is it possible to have nested conditions using Conditional Formatting?
I have a range of columns that change colour according to thei
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 = RE
BOLD........
and so on.......
Basically the first Column Header Font goes From white to Green , th
next column header font goes red, then when that one changes green th
next one goes red etc etc.
If this makes sense to anyone, can it be done
 
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 = RE
BOLD........
Click to expand...

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 wil
need to set your CF in each specific cell you want to change. e.g. i
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 tim
you don't want white is when E67=4

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

HTH

Bruc
 
Back
Top