Keep cell colour when linking

[Lena]

I'm trying to keep the cell colour from the original worksheet when I link
the data to another worksheet, the colour is added manually and not
conditional.
Does anyone know how I can do this?
Many thanks

 

[Luke M]

That is not possible. You could try a picture link (copy cells, then hold
shift and goto Edit - Paste picture link)
The cells won't be editable, but they will look exactly like the source
data, and will update

 

[Lena]

Thank you Luke M, worked fine but unfortunately didn't solve my problem.

 

[Gord Dibben]

Linking formulas cannot copy the color.

All formulas can do is return values.


Gord Dibben MS Excel MVP