Conditional formatting to color cells
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 |
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? |
All times are GMT +1. The time now is 08:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com