I am trying to make a certain cell on my sheet light up based on what week it is.

Each cell contains the value Week X where the X is a week-number.

After a little bit of experimentation I have made the following: enter image description here

Here the cells A4:A56 are the cells with Week X in them.

I want each one each week to light up in beautiful yellow based on the week, but instead, this does nothing (no cells turn yellow).

Is there any way I can get my desired result with conditional formatting in Google Sheets?

Update (an attempted answer made by Rubén, did not work):

enter image description here

  • Add sample data to the question and a link to a demo spreadsheet shared with anyone with the link can view.
    – Rubén
    May 17, 2019 at 15:03

2 Answers 2




  • 1
    Works perfectly, thank you very much!
    – ViRALiC
    May 20, 2019 at 7:28

To use a formula for conditional formatting, instead of Text ends with select Custom Formula.

Then use a formula like the following

  • I attempted your solution but no change was made to any cells, sadly. Did I make a mistake?
    – ViRALiC
    May 17, 2019 at 14:17

Your Answer

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

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