Wanting a schedule to highlight names when scheduled twice or when not scheduled at all.

[Yackety Yack]

I am creating a schedule for my work. I would like to have a column with the employees name highlight green if they are not on the schedule and highlight red if they show up multiple times. I do not want the names to highlight on the schedule itself only on the column that has the employees names on it. I am going to be saving it as a pdf after so It would be nice to have the column that is highlighting to be on another sheet if able. Although I don't know if that will make it complicated bouncing back and forth between pages. Any help on this is appreciated. I've attached an example document for reference.

[Greg M]

Hi there,

Take a look at the attached version of your workbook and see if it does what you need. It uses the following formula in cell H4, which is copied downwards:

Please Login or Register  to view this content.

Cells G4:G10 are conditionally formatted with red/green backgrounds dependent on the values in cells H4:H10.


Hope this helps - please let me know how you get on.

Regards,

Greg M

[Logit]

You missed "Troy"

[Greg M]

No I didn't. I didn't miss "Brad" either. The OP asked about "the column that has the employees names on it", not about the schedule.