title: How can you autofill conditional formatting on Google Sheet with data anchored on one cell?
body: <p>I have conditional formatting on cell B2 based on data in cell B100. ex: Custom Formula is  </p>
  
  <pre><code>=B2&gt;B100  
  </code></pre>
  
  <p>I would like to autofill conditional formatting for all subsequent cells in column B based also on B100. ex: Custom Formula is  </p>
  
  <pre><code>=B3&gt;B100
  =B4&gt;B100
  =B5&gt;B100
  ETC
  </code></pre>
  
  <p><strong>ALSO,</strong> would like to autofill the same conditional formatting across other columns. ex: Custom Formula is</p>
  
  <pre><code>=c3&gt;c100   =d3&gt;d100
  =c4&gt;c100   =d4&gt;d100
  =c5&gt;c100   =d5&gt;d100
  ETC  
  </code></pre>
  
  <p>I want to autofill this conditional formatting so I don't have to do each cell by hand; I have about 450 cells I want to apply this formatting to.</p>