I have 3 columns with specific dates. The first is a start date, the second is set up to be a week later. The third is blank right now. I have a conditional entered so that if the second column is past the date it will change color to alert me. I want to enter a returned date into the third column and add another condition to the second column that returns the cell color back to original when it is entered. I could use some help figuring out the conditional formula please.
January 15, 2014 2:27 PM