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?

Evelyn

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

Then CopyPaste SpecialPaste Links and Paste SpecialFormats.


Gord Dibben Excel MVP

On Tue, 5 Jul 2005 11:45:03 -0700, Evelyn
wrote:

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?