| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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..... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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..... |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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..... |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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..... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting Based of Cells Based on Data Entry in anoth | Excel Discussion (Misc queries) | |||
| Calculate Ending time using Start Time and Elapsed Time | Excel Worksheet Functions | |||
| Elapsed Time formatting | Excel Discussion (Misc queries) | |||
| conditional formatting or formulae to show elapsed dates | Excel Worksheet Functions | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Linear Mode
