View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kristy_6278 kristy_6278 is offline
external usenet poster
 
Posts: 13
Default Conditional Formatting - Times

tHow can I work out using conditional formating that this employee is double
booked with the time scheduled falling in between a current workshop he is
already scheduled at? I have one colume called Scheduling conflicts which I
want to have a formular that comes up red when an issue has occured.

Employee Name Date Scheduled Start Scheduled End
Bates, Jay October 6th 9:00:00 AM 5:00:00 PM
Bates, Jay October 6th 12:00:00 PM 1:30:00 PM

--
WitkosRobinson