title: Apply conditional formatting to many rows
body: <p>I have a data validation set up for a list to choose from (B7:B1000), only two words can be selected: <code>PP</code> or <code>SW</code>. I have figured out a conditional format to fill the row if <code>PP</code> is selected but I need to apply this to the whole spreadsheet. I am having to apply conditional formatting for every row and it's time consuming if I need to do this for 1,000 rows.  </p>
  
  <p>I selected <em>Use a formula to determine which cells to format</em>. This is what I currently have it set up as:  </p>
  
  <pre><code>=B7="PP" conditional formatting to be applied to =$F$7:$N$7  
  </code></pre>
  
  <p>I now need to do this for all rows in the spreadsheet:  </p>
  
  <pre><code>=B8="PP" conditional formatting to be applied to =$F$8:$N$8  
  =B9="PP" conditional formatting to be applied to =$F$9:$N$9  
  =B10="PP" conditional formatting to be applied to =$F$10:$N$10  
  </code></pre>
  
  <p>and so on.</p>
  
  <p>Is there a quicker way rather than manually doing this for 1,000 rows?  </p>
  
  <p>I have tried the format painter but its just copies the previous formula. Tried removing the <code>$</code> symbols but when I click <code>Apply</code> they are re-inserted.</p>