| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
change fill color of a range of cells based on color of a cell?
I want to change the color of a range of cells based on the color of a
different cell. How do I do this. I tried conditional formatting but this only lets me specify the color in the conditional formatting box. It does not allow me to point that to a cell and a color reference. For example - cell A1 is red - change cells A5-A8 to red. Cell B1 is green - change cells B2-B11 green etc.. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In excel change color of a range of cells based on a cell value | Excel Worksheet Functions | |||
| Summing cells within a column based on cell fill color | New Users to Excel | |||
| Is there a way to count cells in a range based on fill color? | Excel Worksheet Functions | |||
| Change fill color based on value of another cell in Excel | Excel Programming | |||
| How do I change fill color in excel based on data in the cell | Excel Worksheet Functions | |||
Linear Mode
