Hi,
If i want to create a duty schedule for my employees and i want to check the clash of duty for a person.For example
John has a schedule for Monday 9.30 to 10.30 in Department A.... if i enter the same name for Department B on Monday 9.30 to 10.30
excel should show an error and highlight cells for clash of duty as he cannot do the duty at the same time in two different departments.
Please help how to highlight if there is a clash
If i want to create a duty schedule for my employees and i want to check the clash of duty for a person.For example
John has a schedule for Monday 9.30 to 10.30 in Department A.... if i enter the same name for Department B on Monday 9.30 to 10.30
excel should show an error and highlight cells for clash of duty as he cannot do the duty at the same time in two different departments.
Please help how to highlight if there is a clash