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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top