|
|
#1
04-20-2015, 09:08 AM
|
|||
|
|||
Question re: Conditional formatting (cell occurs after another cell)
Example:
D3 is "3/31/2015 7:30:00 PM" D4 is "4/1/2015 12:00:00 AM" I would like D4 to be automatically formatted (red text) because it occurs longer than 3 hours after D3. Is this possible? Slightly different, D5 is "=NOW()", would the formatting for the above also work on the date that D5 gives (will be 48 hours). Thank you very much, Micheal 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Conditional Cell Formatting: Alternating Cell Checks | corbott | Excel | 4 | 12-16-2014 01:51 PM |
| Conditional Formatting based on Value of Another Cell | SteveBump | Excel | 3 | 03-07-2014 09:16 AM |
| Conditional formatting value change of same cell | tcalhoun | Excel | 0 | 04-25-2013 07:25 AM |
 Conditional formatting question based on cell date
|
Cosmo | Excel | 2 | 04-08-2013 12:12 PM |
| How can I fill cell color starting from Cell D5 using Conditional formatting instead | Learner7 | Excel | 0 | 07-08-2010 05:50 AM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode