Tuesday, February 13, 2018

yogi_Conditionally Format A:B If Date In Column B Is Less Than 6 Months Away From Today

Google Spreadsheet   Post  #2365

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Feb-13-2018

question by: Lowcountry Concrete
Cell color change alert for upcoming due dates.
I have searched and found a few topics pertinent to this question, but unable to find an answer.  I am trying to keep track of employee certifications and would like to create a spreadsheet that would change the cell color when the date comes to 6 months prior to expiration.  Ideally, I would like an email reminder, but do not see that as an option without and add on and I have done that with no success.  I know this is a simple fix, but can't figure it out