Can this be achieved by Google Sheets conditional formatting feature?

enter image description here

  • 1
    If you had dates above MTWTFSS as headers, It would be easier(the row data header need not be visible). – TheMaster Jun 23 '18 at 17:38
  • I think that should be possible to add them. How would that change it? – orschiro Jun 24 '18 at 4:46

Just type in a function yielding a number for each cell colour you want to use, and set the text colour to none, like:


This will yield 1 if the date on line 3 is between those of columns D and E, and zero otherwise.

| improve this answer | |

Create a demo sheet.

A2(start date): 2018-06-23 B2(end date): 2018-06-26


 2018-06-23 2018-06-24  2018-06-25  2018-06-26  2018-06-27  2018-06-28  2018-06-29

Conditional formatting custom formula:


Apply to:


All of C2:I will be formatted according to the dates in A2:B.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.