Conditional Formatting duplicates with four criteria

[L plates]

Hi All,

I have a scheduling work sheet that is split into two distinct sections - Day sales and Evening sales. Due to the size of the sheet I have added a command button to toggle between the Day and Evening sections which hides or unhides rows with each click and makes it easier for staff to read. Staff are required to be able to tell if they have been given more than one task on the schedule and if thay have been included on the Evening section of the schedule.

The criteria for the conditional formatting of duplicate entries is as follows:

1) When a staff member is duplicated on the Day section only, their name will be highlighted orange. (This was easy...)
2) When a staff member is duplicated on the Evening section only, their name will be highlighted blue. (Also easy...)
3) When on a single task for the Day section and included in the Evening section once or multiple times, their name will be highlghted blue. (Also simple but does not allow for criteria 4)
4) When on multiple tasks for the Day section and included in the Evening section once or multiple times, their name will be highlghted purple.

I have had partial success using excel's built in, highlight unique or duplicate values conditional formatting but cannot get near to the inclusion of the fourth criteria. I have attached a much cut down version of the sheet to illustrate what I am trying to achieve. One sheet shows the 'toggled' version, the other an expanded view with button disabled.

On both sheets:
MONDAY shows an example of criteria 1
TUESDAY shows an example of criteria 2
WEDNESDAY shows an example of criteria 3
THURSDAY shows an example of criteria 4 where i have no formatting to handle this criteria
FRIDAY shows an example of criteria 4 if there was formatting to address the criteria
SATURDAY shows examples of all criteria working together in the one column

Is there a way of formatting the staff columns to echieve the four criteria simultaneously? I am at a loss. Any solutions or tips would be very much appreciated!

Regards,

[sourabhg98]

Hi
See the attached if this is what you need....
Hope it helps!
Sorry if I misunderstood the problem..

[L plates]

Hi sourabhg98,

Sorry for the late reply. Yes this did help and was exactly what I was looking for! Many thanks for your assistance. Most helpful!

Regards,