I have tried using a variation of formulas mentioned in previous questions but can't find a way to make it work for me. I have a list of dates in "I column" for the Due Date and a list of dates in "J column" for the Response Date. I am trying to create a formula that will; turn the Response Dates in the list red when the Response Date is greater than the Due Date, turn the Response Dates in the list green when the Response Date is before than the Due Date, and keep the Response Dates in the list black when the Response Date is the same as the Due Date.
Can anyone please help????
