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

AfterCallWork	15:58:03
Available	1:49:16
Busy	0:03:24

<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>
</tbody>

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

<tbody>
</tbody>