Shift Work Calendar - Conditional Formatting Formula

[CPAC]

Hi, I'm trying to create a shift work calendar. I've attached an example of what I'm trying to achieve but please note it doesn't work as required...

I'd like to use the information on the "details" worksheet to control the conditional formatting on the "January" worksheet.

eg. I want the conditional formatting formula to look at the name in cell B8,B9,B10 etc. then match and look up the information from the "Details" worksheet (start date, shift pattern, shift code).

If an employee changes eg from Shift1 to Shift2 the conditional formatting colour would also need to change (four shift patterns, four different colours)

Any help would be much appreciated.

[6StringJazzer]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)