Conditional formatting based on elapsed time
 

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

Conditional formatting based on elapsed time
 

Assuming starttime in column A and endtime in column B

Select B1:B10 or whatever range you want and FormatCFFormula is:

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


Gord Dibben MS Excel MVP


On Wed, 19 Aug 2009 14:54:01 -0700, Dan Robles
wrote:

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

Conditional formatting based on elapsed time
 

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

"Gord Dibben" wrote:

Assuming starttime in column A and endtime in column B

Select B1:B10 or whatever range you want and FormatCFFormula is:

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


Gord Dibben MS Excel MVP


On Wed, 19 Aug 2009 14:54:01 -0700, Dan Robles
wrote:

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

Conditional formatting based on elapsed time
 

Sounds good to me.


Gord

On Thu, 20 Aug 2009 08:35:02 -0700, Dan Robles
wrote:

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

"Gord Dibben" wrote:

Assuming starttime in column A and endtime in column B

Select B1:B10 or whatever range you want and FormatCFFormula is:

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


Gord Dibben MS Excel MVP


On Wed, 19 Aug 2009 14:54:01 -0700, Dan Robles
wrote:

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