I have a sheet where column E lists statuses of jobs and column N has the due date for the job. What I'd like to do is colour code the date so that the date appears red if the due date is before today's date and the status is any other status other than complete. Would appreciate some help on how to do that.

marked as duplicate by Rubén, serenesat, jonsca May 25 '18 at 21:58

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.


Use a Custom formula in your Conditional format rules. Suggested formula:

=AND(E1<>"complete", N1<TODAY())

Not the answer you're looking for? Browse other questions tagged or ask your own question.