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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top