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.
Comments
-
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.
Jim
-
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.