Conditional formatting based on elapsed time

  • Thread starter Thread starter Dan Robles
  • Start date Start date
D

Dan Robles

I've been reading question and answers all morning but can't quite find the
help i need. I am making a spreadsheet that tracks attendance. I have two
columns for start and end times both formatted as time. What I need is a
method to highlight cells if a user enters an end time that is prior to the
start time; but I do not want it to consider blank cells for EndTime. So far
all my attempts at conditional formatting are kicking my rear.
Please help. the boss is watching.....
 
Assuming starttime in column A and endtime in column B

Select B1:B10 or whatever range you want and Format>CF>Formula is:

=AND(ISNUMBER($B1),$B1<$A1)


Gord Dibben MS Excel MVP
 
Back
Top