With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Tuesday, February 13, 2018
yogi_Conditionally Format A:B If Date In Column B Is Less Than 6 Months Away From Today
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