title: Format the last cell only with value equal or higher than X
body: <p>How do I use conditional formatting to format only the last cell in each column with a minimum value ?<br>
  This implies a non-VBA solution.</p>
  
  <p>I have tried using this formula, but it stops after first match (5 is formatted):</p>
  
  <pre><code>AND(A2&gt;=5,COUNTIF($A$2:A2,"&gt;=5")=1)
  </code></pre>
  
  <p>Using this data, only 9 should be formatted.  </p>
  
  <p><strong>Data</strong>:</p>
  
  <pre><code>1
  2
  3
  4
  5  &lt;-- actual result
  6
  7
  8
  9  &lt;-- expected result
  </code></pre>
  
  <p><strong>UPDATE:</strong><br>
  This formula seems to do the trick, but only works when the cell values in the range are numeric, which mine are, and <strong>only</strong> in 1 column. Range must match format area.<br>
  Note: I found the "INDEX..E+307" part somewhere else, but lost the URL so cant give credit.</p>
  
  <pre><code>AND(A2&gt;=5,A2=INDEX($A$2:A10,MATCH(9.99999999999999E+307,$A$2:A10)))
  </code></pre>
  
  <p>A multi-column supported formula is now needed. Using <code>OFFSET</code> might be the way to go..</p>