Conditional formatting to color cells

[Guest]

I need to use conditional formatting to color or inactivate color in a column
of cells.
If A1 is a drop down menu referencing numbers 1-8. I want
B1,C1,D1,E1,F1,G1,H1,I1, to reflect that number,
I.E.
If the number in A1 is 4, then 4 cells should uncolor from say a base color
of red.
how do i accomplish this?

 

[Gord Dibben]

You have B1:I1 colored red.

You have a DV list in A1 from 1-8

Select B1:I1 and CF>Formula is: =$A$1=4

Format to no color.

If you want a different color for for each number, you will need code since
there are only a max of 4 conditions(counting default) in Excel versions earlier
than 2007


Gord Dibben MS Excel MVP