Tuesday, February 27, 2018

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,
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