View Single Post
  #1   Report Post  
PamHR
 
Posts: n/a
Default conditional format for duplicates

Hello,
I have a schedule of 200 employees, and 33 shifts/locations, that changes
daily. I have all schedules in one workbook. I'd like a conditional format
that notifies me when one employee has been placed on more than one worksheet
- in other words, I want no duplicates of employee names in a workbook. Any
suggestions?
Thanks!