Conditional formatting to color cells
You have B1:I1 colored red.
You have a DV list in A1 from 1-8
Select B1:I1 and CFFormula 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
On Mon, 14 May 2007 21:08:06 -0700, NealMed
wrote:
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?
|