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.
Bookmarks