yogi_Conditionally Format Column B Based on Bands Of Days To Completion

Google Spreadsheet   Post  #2384

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

question by: Mike Surgey
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/RAJLVBJGq0k;context-place=forum/docs
Conditional Format For a Series of Date Ranges
Hi everyone,

https://docs.google.com/spreadsheets/d/1hxAYX7vcInovxauyd4nrX-r-0mEiz2ZjIGdfaUA8Yzw/edit?usp=sharing

I have an order date and a deadline, which is 21 days after the order date.

I would like to use conditional formatting to highlight column C for 4 scenarios.

- days 1-7 a colour

- days 8-14 another colour

- days 15-21 different colour

- all days after the deadline Red

All help much appreciated