|
|
#17
04-25-2012, 04:16 PM
|
||||
|
||||
Quote:
That's because you're actually working with a time format and times cannot be negative. However, you can use:
=ABS(C11-C9) and combine this with a conditional format that uses the formula =C11<C9 and colours the cell accordingly.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Date Calculation
|
Lights | Excel | 5 | 04-18-2012 04:31 AM |
| calculation of start date | ketanco | Project | 1 | 02-29-2012 07:01 AM |
|
Formula calculation
|
danbl | Excel | 8 | 02-23-2012 04:35 AM |
|
Calculation within Cells
|
manich1 | Excel | 2 | 12-07-2011 02:59 PM |
| Angle Bracket Problem, STYLEREF in Header of a Protected Document | wordjunkie | Word | 0 | 06-18-2010 04:34 AM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode