Keep cell colour when linking

  • Thread starter Thread starter Lena
  • Start date Start date
L

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
 
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
 
Linking formulas cannot copy the color.

All formulas can do is return values.


Gord Dibben MS Excel MVP
 
Back
Top