Match a cells background color to another cells background color

**cmb3587** · 01-10-2011, 01:30 PM

In my excel sheet, I have a few cells that relate...cells C6:C15 need to record the value (usually text) typed into cells C36:C45 respectively. However they also need to have the same background color chosen from the status column D36:D45. The status column is a drop down menu that selects a status based on a color code key. The key has 3 colors so conditional formatting was used to have the drop down menu match the color code key when a specific status is selected. I would like the colors in C6:C15 to update automatically when the statuses in D36:D45 change.

I have tried some VBA but I'm new to it and can't find anything that works. Any help will be appreciated!

**NBVC** · 01-10-2011, 01:33 PM

Can't you use the same conditional formatting rules as you did in D36:D45?

**cmb3587** · 01-10-2011, 01:40 PM

The conditional formatting is based on the text used in the status column. If the status from the drop down menu at D36 is selected to be low it changes the color of D36 to green. C36 will have text typed into it. I need C6 to show the text typed into C36 but have the color of D36.

**NBVC** · 01-10-2011, 01:48 PM

You can say for example for condition in C6...

=$D36="low"

and choose format colour: Green.

**cmb3587** · 01-10-2011, 02:01 PM

I'm going to try to explain it a little better this time, sorry. I have a drop down box at D36. The drop down allows me to select 3 different choices: low, medium, or high. I used conditional formatting so that if low is chosen the color of D36 turns to green, if medium is chosen its yellow and if high is chosen it is red. C36 is strictly a text field and has no color formatting. The text typed into C36 can be anything. I need C6 to update to show what is typed into C36 and update the background color to match the background of D36.

Example

C36 = "Thin wall"
D36 = selected "High" from drop down (D36 is now highlighted red)

C6 needs to update to show: "Thin wall" and be highlighted red