title: Apply conditional formatting to subsequent cells in Google Sheets
body: <p>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:</p>
  
  <ol>
  <li><code>=(WEEKNUM(A$2)=WEEKNUM(TODAY()))</code> in A1:AS1</li>
  <li><code>=date(xxxx,xx,xx)</code> in A2:AS2 (and then <code>=A2+7</code> in subsequent cells)</li>
  <li>apply conditional formatting to cells A3:A60</li>
  </ol>
  
  <p>The only reason I've used the first step is because I couldn't get combining the formula to work in conditional formatting.</p>
  
  <p>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.</p>
  
  <p>How do I apply conditional formatting to columns B:AS and have it relate to cell 1 of any given column?</p>