I have three columns,
Column 1 = Start Date
Column 2 = End Date
Column 3 = Close Date
I need to place a conditional format or and "IF" statement on columns 2 and 3. Stating if column 2 is after or 1 month from today's date highlight in RED. And column 3 should state if column 3 is less than 3 months from todays date highlight in yellow. Please HELP!!!
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!
No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.
Your password has been sent to:firstname.lastname@example.org
To follow this tag...
Thanks! We'll email you when relevant content is added and updated.
Share this item with your network: