Conditional Fomating Question

Hi, I'm stuck on figuring out some conditional formatting.

I have two date columns "Due On" and "Completed On" and would like to turn the Due On cell green if the Completed On date is before the Due On date. On the same coin, then I want to turn the Due On cell red if Completed On date is after the Due On date. I've figured out how to turn them colors if overdue and NOT completed but not once it is completed.


  • Jim Hook
    Jim Hook ✭✭✭✭✭✭

    Samantha, probably the easiest way to make a cell one of two colors is to format the cell color green, for example, and then turn it red with conditional formatting if the condition is true. I may not completely understanding what you're trying to do so you may have to have more than one conditional formatting rule for the same column and the first rule that has the condition true will take precedence.


  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    Hi there, you can add multiple conditions to a Conditional Formatting rule. Like you could put, if the due date is in the past, and the status contains specific words... To add an additional rule, click on the little arrow to the left of the rule. See my screenshot below.