OK probably a very basic copy & paste solution to this but cant see it.
I've got a cell with a number in it and conditional formatting attatched to it.
So when a certain value is entered it turn either Red Amber or Green.
I would like to have this appear the exact same (with cell colours) on a different sheet.
I can obviously do =sheet1!A1 but that only takes the value and not the colour its changed to.
Is this possible with out doing the conditional format on every sheet?
Thanks for any help,
Ewen
Bookmarks