Overlay worksheets with formatting

My firm currently uses Excel to manage its production programme. We have rows for different jobs and columns with dates.

Each person at the firm has a colour. the relevant cell is filled with the person's colour to indicate they're working on that jobs that day. A note is often added to indicate the particular task. A sample is attached - or it would be if that button worked! I'll upload the thread and hopefully be able to add the attachment...

Management are considering splitting the programme into three (Design, Production, and Engineering) so that different people can manage different areas of work.

I've been asked to investigate ways of overlaying these three programmes so that they can be viewed together. Everything I've come across seems to take the values of cells but not the fill colour.

I was hoping someone here could suggest something?

dJE