title: Conditionally format a range based on a different range
body: <p>Given the sheet:</p>
  
  <pre><code>A| B | C = SUM($D2:$Z2) | D | E | F | ...
  </code></pre>
  
  <p>How would I, for a range of rows (for example: <code>4:50</code>), color columns <code>Cx:Zx</code> (for row <code>x</code>) if <code>Bx &gt; Cx</code>, without making a conditional rule for each individual row and/or each individual column?</p>
  
  <p>(Assume there are a lot of rows and a lot of columns.)</p>