Conditional formatting based on column date
Hello, I am trying to change the status of an action item to Red or Green based on the date it was completed.
The logic in my head, reads as follows (if (Completed>EndDate)) -> RED, else Green
but when using condition formatting , its not allowing me to select the EndDate column, instead its asking me to put a specific date.
I have attached a screen shot