linking colored cell

[Gerbatin]

I have a worksheet(A) with data linked to a second one(B); when I forma
any (A) cell with a selected color, I would like to transmit the ne
cell color to the linked one in (B); suggestions will be welcome

 

[Gord Dibben]

Cannot be done unless Condtional Formatting is used on both cells to produce
the color.

OR VBA code.

Gord Dibben Excel MVP