Apply conditional formatting to subsequent cells in Google Sheets

0
votes

I have been trying to find a way to highlight a column when the date in row 2 is within the current week. I've done this by using:

  1. =(WEEKNUM(A$2)=WEEKNUM(TODAY())) in A1:AS1
  2. =date(xxxx,xx,xx) in A2:AS2 (and then =A2+7 in subsequent cells)
  3. apply conditional formatting to cells A3:A60

The only reason I've used the first step is because I couldn't get combining the formula to work in conditional formatting.

When I highlight A1:A60 and "drag" them to the right, the "apply formatting to" field contains ALL of the cells highlighted, and the custom formula only looks at cell A1.

How do I apply conditional formatting to columns B:AS and have it relate to cell 1 of any given column?

1
google-sheetsgs-conditional-formatting

1 Answers

0
votes

Not sure if I completely understood your question. But if you want to color a row (in the range B:AS) when column 1 of that row contains a date that falls in the same week as today, then ..

  1. set up the range to B1:AS1000

  2. use this custom formula

    =WEEKNUM($A1)=WEEKNUM(TODAY())

Change ranges to suit and see if that works ?

EDIT: Based on the comment below

  1. set up the range to A3:A60

  2. Use this custom formula

    =WEEKNUM($A$2)=WEEKNUM(TODAY())