![]() |
#1
|
|||
|
|||
![]()
I am creating a construction punch list with 5 columns, two of the columns are DUE DATES and COMPLETED DATES. I am trying to get the Due Date cells to turn red once the date entered has passed and as long as there is no date entered into the Completed dated cell. I am also trying to have the completed date cell turn green once a completed date is entered and have the due date column to turn back white. Is this possible?
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional Formatting - color only dates contained in a range | EC37 | Excel | 1 | 07-08-2014 12:51 PM |
![]() |
info_guy2 | Excel | 1 | 07-03-2014 10:07 AM |
Conditional Formatting - past due dates | namedujour | Excel | 1 | 06-27-2014 04:16 PM |
![]() |
namedujour | Excel | 1 | 02-21-2013 03:42 AM |
Conditional Formatting Expiration Dates Based on Text in Adjacent Cell | Frogggg | Excel | 1 | 10-25-2011 08:44 PM |