title: Excel Conditional formatting to highlight duplicate cells multiple colours
body: <p>I have a column of numbers which I would like excel to highlight if the numbers are duplicates. However, I want each set of duplicates to be highlighted a different colour. So for example, using the sample data below, I might want all instances of 1111 to be highlighted yellow, all instances of 1122 to be highlighted green and all instances of 1344 to be highlighted red. The colour that the duplicates are highlighted does not really matter, as long as each set of duplicates is a different colour. </p>
  
  <p>I have tried using conditional formatting to highlight the duplicate cells, but it only highlights everything in 1 colour which makes it hard to differentiate between the groups of duplicates when the groups are all contiguous.</p>
  
  <pre><code>Column A:
  
  1111
  1111
  1122
  1122
  1122
  1344
  1344
  1153
  </code></pre>