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?