title: Apply conditional formatting to compare multiple rows and columns to a reference column
body: <p>I have a Google sheet of this form:</p>
  
  <p>&nbsp;&nbsp;&nbsp;<strong>A</strong>&nbsp;&nbsp;&nbsp;B&nbsp;&nbsp;&nbsp;C&nbsp;&nbsp;&nbsp;D&nbsp;&nbsp;&nbsp;E<br>
  1 <strong>A1</strong> B1 C1 D1 E1<br>
  2 <strong>A2</strong> B2 C2 D2 E2<br>
  3 <strong>A3</strong> B3 C3 D3 E3<br>
  4 <strong>A4</strong> B4 C4 D4 E4<br>
  5 <strong>A5</strong> B5 C5 D5 E5</p>
  
  <p>The column $A contains reference values to which I want to compare the rest of the table.
  The formatting I want to do is simple: </p>
  
  <p><code>For each row x of the table:</code></p>
  
  <p>&nbsp;&nbsp;<code>For each column β in columns (B:Z) of the table:</code></p>
  
  <ul>
  <li><em>apply color green</em>: <code>if the cell βx is greater than $Ax</code></li>
  <li><em>apply color red</em>: <code>if the cell βx is less or equal to $Ax</code></li>
  </ul>
  
  <p>I have tried a custom formula with <code>=$A1:$A&gt;B1:Z on range B1:Z</code>, but it doesn't work.</p>
  
  <p>This formula works on only one column (for example B): <code>=$A1:$A&gt;B1:B on range B1:B</code>.
  I'm just now looking for a way to apply this formatting to all columns at once, without having to rebuild the conditional format manually for each column (hundreds of columns is a lot..)</p>