Recognizing Duplicates, Highlighting rows

  • Hello,


    If I have a list of information, I wish to run a hotkey triggered macro that can recognize duplicate data and highlight the rows they rest in. The two columns that it would 'scan' would be column E and column F. Is this a possibility?


    Attached is a test book of how the list may look.


    Thank you for any help.

    Files

    • testbook.xlsm

      (8.68 kB, downloaded 84 times, last: )
  • Re: Recognizing Duplicates, Highlighting rows


    Hi JSpectrum,


    Try this:



    HTH


    Robert

  • Re: Recognizing Duplicates, Highlighting rows


    Thank you for your help. It works perfectly! I'm just shocked that such a larger code does that tiny task. :smile: