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

"Luke M" wrote:

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
--
Best Regards,

Luke M
"Lena" wrote in message
...
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


.