title: ranges and conditional formatting on google spreadsheet
body: <p>I need to apply a conditional formatting on a range of cells (more rows and more columns).
  The condition must be a compare among the value contained in the cells and the value of another range (single column).</p>
  
  <p>An example in the spreadsheet linked below:
  <a href="https://docs.google.com/spreadsheets/d/1aS9iLkPycb0ABfv3pk8HX9JVS2SmdTJ76Bd5KO_P-gI/edit?usp=sharing" rel="nofollow">https://docs.google.com/spreadsheets/d/1aS9iLkPycb0ABfv3pk8HX9JVS2SmdTJ76Bd5KO_P-gI/edit?usp=sharing</a></p>
  
  <p>I have done it with a conditional formatting rule for each column (n columns => n rules).</p>
  
  <p>I have use a custom formula like this:</p>
  
  <pre><code>=A:A&gt;F:F
  </code></pre>
  
  <p>it compare the value of the cell #i of the column A with the value of the cell #i of the column F.</p>
  
  <p>I tried to write a single formula that cover all the condition without a positive result.</p>
  
  <p>exist a method to do it with one single rule?</p>