| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Conditional formatting w/minutes
xl 2000--I am tracking transaction times and would like to use CF to highlite
times more than and less than 2 minutes. I tried to use "cell value" and it is not recognizing :02, (for instance). What would a formula be that would work to do this? I think I need to convert the answer to a portion of a day? I am using a formula to subtract the start time and the end time. The results are formated as time ie :01, :06, :11, :02 etc. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting in Excel Help Please..... | Excel Discussion (Misc queries) | |||
| Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) | |||
| Copy conditional formatting across multiple rows? | Excel Discussion (Misc queries) | |||
| Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
| Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
