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.. |
All times are GMT +1. The time now is 07:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com