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!
|