I have template that tracks the workers for a department.
I would like to be able to have the font change color if
the worker is late arriving or leaves early. The problem
that I have is that there are 15 workers who start at
various times so conventional condtional formatting will
not work. Here is a partial of what I have

Name Start Finish

Tom 8:05AM 5:00PM
Joe 9:00AM 5:55PM
Pam 6:30AM 3:15PM
Peter 7:03AM 4:00PM

What I would like to happen is to have Tom and Peter's
start time font change to yellow since they were late, and
Joe and Pam's color change as well since they left early?
TIA