yogi_Conditionally Format Column B If Date Is Less_Than_7_days Less Than 1 Month Or More Than 1 Month Away

Google Spreadsheet   Post  #2584

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

question by: Laurence Browne:

https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/wzFydy5DY5c;context-place=forum/docs
Conditional format - Robot system for due dates

Hi 

I have a spreadsheet with multiple coloums for when re-training is required. I would like a robot colour system to easily identify when training is due based of the cell changing colour based on the date

Red - 1 week away

Amber - 1 month away

Green - over 1 month away

i.e. if the date of the cell is 19/11/2021 the cell should be green but if the cell is 07/02/2019 the cell should be red. 

Thank you for any help you can provide.