conditional format for duplicates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
No, not easily. A MUCH better way would be to use one sheet that has a
master list of the 200 employees, and assign them to a shift and a location
on that same sheet, using values entered into columns after their names.
Then use filtering to show just one shift, or one location, or one shift at
one location, or to filter on other information also in the list.

HTH,
Bernie
MS Excel MVP
 
That is a much better idea - thanks so much! I really appreciate your
thoughtful response!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding up total hours worked on employee schedule using various criteria 0
Excel Highlighting duplicates 0
Conditional Formatting - Times 1
Employee Scheduling Worksheet 10
Time Calculations and Conditional Formating 1
Conditional Formatting & Data Validation? 1
Conditional Format Not Working 4
Conditional Formating Highlight Results 1

Back
Top