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, 2018 at 17:38
  • I think that should be possible to add them. How would that change it?
    – orschiro
    Jun 24, 2018 at 4:46

2 Answers 2


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.


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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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