Conditional formatting based on elapsed time

[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.....

 

[Gord Dibben]

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

 

[Dan Robles]

Most Excellent. Thanks Loads. If this gets me a raise, the beers are on me.

 

[Gord Dibben]

Sounds good to me.


Gord

Most Excellent. Thanks Loads. If this gets me a raise, the beers are on me.