I am putting together a tracking spreadsheet whereby we have tasks that need to be done in relation to an end date.
For example, a welcome email needs to be sent 3 weeks before the date. If the cell is still blank TWO weeks before and up to the date of, I'd like the cell to be yellow. On or...