title: Highlight Full Duplicate Rows (Not Individual Values)
body: <p>I have looked at several other stack overflow questions, however I haven't found the answer I am looking for.</p>
  
  <p>I have an excel sheet with 25000 rows in the following format:</p>
  
  <pre><code>userid  |  taskid  |  taskcode
   1      |     3    |     K
   1      |     4    |     O
   1      |     4    |     L
   1      |     5    |     O
   2      |     3    |     O
  </code></pre>
  
  <p>What I want to do is identify any rows that are duplicated considering <code>userid</code> and <code>taskid</code>, in the above example I would expect the second and third rows to be highlighted.</p>
  
  <p>I'm not sure how feasible it is, I'd ideally like to identify the duplicate row containing the <code>taskcode</code> <code>O</code> rather than <code>L</code>.</p>
  
  <p>My end goal is to remove all duplicate userid / taskid rows with the taskcode O regardless of how it is achieved (highlighting then sorting by highlights or using vba).</p>