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
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/71pHOQ9ryAs;context-place=mydiscussions
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