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.