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