Brian,

Do you have (anywhere in the sheet) the correct start and
finish times listed. Because that would make it a whole lot
easier.

Going by what you've got their the only thing I could think
to do would be format the cells based on the difference
between start and finish time (ie check to see if it's 9 hours)
But then you don't know if their late or early.

Dan E

"Brian" wrote in message ...
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