Excel Conditional Formatting 2003

5 pts.
Tags:
Microsoft Excel formatting
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: