One cell's formatting mirrors another

[dgoldman86]

In cell A1 i have a drop down list with conditional formatting in place. Depending on the value i select, the cell A1 will change fill color. I want cell B1 to change fill color to match the fill color in A1.

Simple example: say i select value 1 for cell A1 and the fill color in A1 goes to blue. I would like cell B1 to turn blue also. Then if i change the value of A1 to 2 and A1 fill color changes green, I want B1 to also change to green.

Any help is greatly appreciated.

 

[storm8]

nice!

 

[dgoldman86]

Thank you Snakehips. This was extremely helpful and I got it working on my sheet. Thanks again!

 

[vinaysonu424]

Hello Im looking for VBA code, For example i have some Text in one row and in other row i have the numbers
for Example

<colgroup><col style="mso-width-source:userset;mso-width-alt:5814;width:119pt" width="159"> <col style="mso-width-source:userset;mso-width-alt:2084;width:43pt" width="57"> </colgroup><tbody>
[TD="class: xl66, width: 159"]AfterCallWork[/TD]
[TD="class: xl67, width: 57"]15:58:03[/TD]

[TD="class: xl66"]Available[/TD]
[TD="class: xl67"]1:49:16[/TD]

[TD="class: xl66"]Busy[/TD]
[TD="class: xl67"]0:03:24
[/TD]

</tbody>

[TABLE="width: 216"]
<tbody>[TR]
[TD][/TD]
[/TR]
[TR]
[TD]If d has after call e time has to have the same color if available is green then available time for F row should be green Busy is yellow then F colum time for busy should be yellow please help me with the code... I
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]