Hi,
I am working with large spreadsheets for staff rostering. The main planner
sheet holds info for each staff member acros the columns, and the dates they
are working down the rows. Each staff/date cell ahs a time value (the shift
start time) or a text value (Leave, sick, etc). For the non-shift times ,the
cells are highlighted manually.
I also have a summary sheet, which displays ony 4 weeks at a time, by using
the VLOOKUP formula to select the date's values ,based on a given date on the
summary page.

What I also want to do is copy the cell fill colour from the planner sheet
to the summary sheet - any help would be appreciated.

Stu