+ Reply to Thread
Results 1 to 3 of 3

Need help with this macro on Highlighting Duplicates

  1. #1
    Registered User
    Join Date
    12-30-2011
    Location
    Lagos
    MS-Off Ver
    Excel 2007
    Posts
    6

    Need help with this macro on Highlighting Duplicates

    Hello,

    I got this macro online and it is supposed to highlight duplicate cells in yellow.

    Please Login or Register  to view this content.

    However, I would like to tweak the macro to do the following:

    1. It should compare cells in Column A for duplicates then it should compare the dates (in column H) among the two duplicates and highlight the corresponding row with the most recent date (in yellow).
    2. It should then highlight the corresponding row (in red) with the older date among each set of duplicates.

    I would be very happy if there is a solution for this as i have about 10,000 rows of data to sort according to this criteria. I would not mind if there is a conditional formatting technique to achieve this.

    I have attached a test file so you can see the "Raw Data" in worksheet 1 and the "Result" i would like to achieve in worksheet 2.

    Regards.

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Need help with this macro on Highlighting Duplicates

    Hopefully this is correct

    Please Login or Register  to view this content.
    Last edited by JieJenn; 12-31-2011 at 09:00 PM.

  3. #3
    Registered User
    Join Date
    12-30-2011
    Location
    Lagos
    MS-Off Ver
    Excel 2007
    Posts
    6

    (SOLVED) Need help with this macro on Highlighting Duplicates

    JieJenn,

    Thanks for the code. It really worked a treat.

    I really appreciate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1