How can I link cell colours from worksheet to worksheet/workbook?

E

Evelyn

I am using muliple worksheets / workbooks to manage vacation schedules for
the summer with vacation days colour coded. I have linked the cells from one
sheet / book to another but the colour (formating) doesn't transfer as a
value would.

Any ideas?
 
G

Gord Dibben

Evelyn

One method is to, in some way, use Conditional Formatting to color the cells
on the original sheet.

Then Copy>Paste Special>Paste Links and Paste Special>Formats.


Gord Dibben Excel MVP
 
Top