Google Sheets Conditional Formatting

by ViRALiC   Last Updated May 15, 2019 23:03 PM

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?

Tags : google-sheets

Related Questions

Updated March 03, 2018 02:03 AM

Updated September 19, 2018 13:03 PM

Updated July 26, 2018 21:03 PM

Updated November 29, 2018 16:03 PM

Updated January 18, 2019 09:03 AM