Hi, Excel Stars,

I am puzzled with a task to find the potential time clashes when planning
exams.

After allocating times to diffrent subjects, there will be some of the
students got a timetable as below

Name Subject Date Time
Mary.............................................. ......................
Mary .................................................. ..................
Mary .................................................. ..................
Tom English Tuesday 2/10/08 9.00 am to 11.00 am
Tom Chemistry Tuesday 2/10/08 9.00 am to 11.00 am
Tom Math Wendesday 3/10/08 9.00 am to 11.00 am
Tom Chemistry Thrusday 4/10/08 9.00 am to 11.00 am
Jack .................................................. ......................
Jack .................................................. ....................
Jack.............................................. .........................

Out of 700+ students, there will be 5 to 10 students having time clashes (as
above) on their exam timetables.

Is there any way to use excel functions or macros to highlight the time
clashes?

much appriciated for your help!





--
Jack