Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting on Color | Excel Worksheet Functions | |||
Color Conditional Formatting | Excel Worksheet Functions | |||
Excel Conditional Formatting color multiple cells for 1 logical | Excel Worksheet Functions | |||
Cell Formatting Conditional On Other Cells Fill Color? | Excel Worksheet Functions | |||
Conditional color formatting entries have wild color. | Excel Discussion (Misc queries) |