Hi,

What determines the colour originally is the non-timed shift - eg Annual
Leave (yellow), sick(blue), or what's called Relief(green), which are
un-allocated shifts, which are dependent on other staff absence requirements.

E.g. a staff memeber might have a week of Relief days, which are coloured
green, but then might have to work a couple of timed shifts, 08:00, 16:00,
during that period. What happens with conditional formatiing is that the
Relief (green) cell becomes 08:00 (white) - so I lose that fact that the cell
was/is a relief shift, not a normal rostered one.

As the cells are manually coloured on the planner sheet, this reset of the
cell colour does not occur, but the summary sheet should only be a
re-designed copy, and is therefore not actually updated manually, only be
reference to the planner sheet.

If that makes any sense at all...

"wmjenner" wrote:


What determines the cell color? Is it just colored to distinguish one
cell (or person) from another? If the cell color is tied to some
value, you could use conditional formatting on the target page and,
depending on the criteria for the cell color, it would change
automatically as the criteria change. A little more detail on what
you're trying to accomplish will probably yield more targeted
responses.


--
wmjenner


------------------------------------------------------------------------
wmjenner's Profile: http://www.excelforum.com/member.php...fo&userid=5282
View this thread: http://www.excelforum.com/showthread...hreadid=394243