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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!