title: Highlighting duplicate values in a column in OpenOffice Calc
body: <p>I'm using a Linux machine and I've been trying to find an equivalent to excel's</p>
  
  <pre><code>"highlight Cell Rules &gt; Duplicate Values" 
  </code></pre>
  
  <p>formula that I can use to color cells that have duplicates on the column in OpenOffice Calc. 
  I've already found and tried</p>
  
  <pre><code>COUNTIF(A$1:A$15; A1)&gt;1 
  </code></pre>
  
  <p>as a formula but this doesn't work on every single item in the column vs every single other one.</p>