![]() |
#1
|
|||
|
|||
![]()
Hi,
I am trying to format an excel sheet so that when a specific cell changes color, so does another group of cells. However, I do not want all cells in the group to change color, only the ones that have data entered. For example, if cell A1 is the independent cell, changing its color will change the color of all cells A2:A10, but only for the ones that have something entered in, leaving the rest as no-fill. Furthermore, I would like it so that if I enter data in any of the cells in the group (A2:A10) that it will automatically change color to be the same as cell A1. To summarize, I pretty much want the group to act as though it is conditionally formatted for non-blank cells, while responding to the color of one particualr cell. Is this possible and, if so, how can I do it? Thanks, Alex |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
How can I fill the below emty cells with above cell data? | Learner7 | Excel | 8 | 06-28-2011 12:10 PM |
![]() |
click4akshay | Excel | 2 | 04-28-2011 01:51 PM |
How can I fill cell color starting from Cell D5 using Conditional formatting instead | Learner7 | Excel | 0 | 07-08-2010 05:50 AM |
![]() |
themangoagent | Excel | 1 | 02-20-2010 11:29 AM |
![]() |
Leanne | PowerPoint | 1 | 11-04-2009 08:34 PM |