View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Char Char is offline
external usenet poster
 
Posts: 6
Default Prevent duplicate data from being entered into the same column

Hello,
I am trying to do a work schedule in Excel 2003. I have a drop down box
listing all my employees names. The problem is my managers were selecting the
same employees to do different jobs creating a schedule conflict. I want to
be able to prevent this from happening so I wanted to have the names turn red
or an error message pop up to prevent this. I am stumped any suggestions?
Please help