Hello,
I got this macro online and it is supposed to highlight duplicate cells in yellow.
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.
Bookmarks