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

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 Copy>Paste Special>Paste Links and Paste Special>Formats.


Gord Dibben Excel MVP

On Tue, 5 Jul 2005 11:45:03 -0700, Evelyn <Evelyn@discussions.microsoft.com>
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?

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

On Tue, 5 Jul 2005 11:45:03 -0700, Evelyn <Evelyn@discussions.microsoft.com>
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?