Hello All,
Conditional formatting is relatively new to me. I have a spreadsheet that list various certification dates for my employees. Some of those certifications expire annually, and some expire every two years. I need all the dates to turn yellow 60 days prior to their expiration, and red upon expiration. I have received some help and have the annual dates already formatted, but I'm having problems with the 2 year expiration. Please note that the dates in question are the certification dates, not the expiration dates. For example:
7/30/10 - I would like this to turn yellow on 5/30/12 and turn red on 7/30/12
Any help would be appreciated!! Thanks!
Bookmarks