Keep the colour of the cell when you link it out to another sheet

Hello,

How can I keep the colour of the source cell when I either link it out to another sheet - I have tried the simple "Link from Cell in Other Sheet..." and also a Vlook up but the colour doesn't come with the text

Any solution please?

Thank you

Karne

Answers