How can i highlight a Month row based on today() in Google Sheets

1
votes

I have a 12 rows containing from January to December and 31 columns representing the day of month.

I used the formula =TEXT(today(),"mmmm") in cell b1 to get the name of the month ie: August.

How can i change the background color of the whole row of August.

I know i should work with Format->Conditional Formatting:

Check Image

Sheets is NOT coloring the specific month.

I used: Apply to range A:AF AND Custom FORMULA is: $A=$b1

1
google-sheets

1 Answers

1
votes

Please clear any CF from A:AF and try selecting A1:AF14, Format - Conditional formatting..., Custom formula is: 

=$B$1=$A1

with formatting of your choice.

Assumes your month names are Text.

Selecting the range sets the Applies to criteria and since it is often easiest and most versatile (eg regarding insertion and deletion of rows) to choose whole oolumns, the associated formulae will normally need to start from Row1.