title: Conditional Formatting with Formula using Relative References
body: <p>I looked around for an answer to this and found a similar thread, but it did not quite answer my question so here goes.</p>
  
  <p>I have two columns, each with 262,000 rows of data.  I am trying to highlight data in one of the columns based off of two conditions.  I think I have the formula right for the conditional formatting, but the problem is that it will not apply to the entire column as I want it to.  For example:</p>
  
  <p><code>=AND(K6&lt;=1638, L6=0)</code></p>
  
  <p>That's the formula I have.  I want that formatting to copy and paste all the way down column K, iterating each time.  For example, the cell below should have formatting that says the following: <code>=AND(K7=1638, L7=0)</code> but I cannot get it to this.  It just keeps looking at the values in cells K6 and L6.</p>
  
  <p>Is format painter not the way to get this formatting applied to each cell?</p>