link color fill from one worksheet to another

[erregsec]

I am attempting to set up a schedule in Excel. I have one page that has all
of the employees on it. Then different worksheets with only those employees
that are in the individual departments. I have it set up so I can make
changes on the "all" sheet and the other department sheets are linked to
change. When an employee requests a vacation day I want to mark it with a
certain color so I can easily see what days I need to cover. Is there any way
that I can change the fill color in the "all" page and have the fill color
also change in the individual department page? Same question with comments?
Thanks for helping. Using Excel 2003.

 

[Dave Peterson]

Not really.

Excel doesn't push values/formatting to other worksheets. It can pull values
(but not formatting) by use of formulas.

But depending on the version of excel and how many different shades you need,
you may be able to apply data|validation to each of the ranges in each of the
sheets to get what you want.

There's nothing built into excel that allows you push Comments from one sheet to
another.

======
As for me, I'd keep all the data on one sheet. I'd add an indicator for
department and then filter by whatever department I wanted to see.

By keeping the data in one spot, I don't have to worry about the data getting
out of sync, either.