title: Excel Finding or Highlighing Duplicates with 2 columns as basis
body: <p>I am not sure if there is an existing question like this one. I will remove this post if there is any.</p>
  <p>For example (I manually highlighted the duplicates in yellow using an image editor)
  <a href="https://i.stack.imgur.com/MFqkJ.jpg" rel="nofollow noreferrer">https://i.stack.imgur.com/MFqkJ.jpg</a></p>
  <p>In the list, I only want to highlight if the date and the code beside it are duplicated on the next/consecutive row.
  I can sort the list based on the dates, however, I do not want to highlight it if the codes are not of the same date as well</p>