Find & highlight rows using VBA

Hi Experts,

I need to highlight duplicate rows based on 3 columns using VBA.

This is what I am looking for.

Compare the values in column B, F & H.
Highlight the duplicate values in column F & H. Also highlight the newest value in "Green" in column L & M based on the date in column B. I've attached a sample spreadsheet.

I tried using the conditional formatting with formula but my spreadsheet is freezing and lands in to recovery mode. The file has more than 10000 rows.

Hi nankw8,

Thanks for the code it works like charm.

However, I missed to inform that Rows 1 & 2 are merged as these are the headers, these rows doesn't require to highlight duplicates. Also, column O has formula and is being removed when I run this code.

Can you post a sample file that mimics your original file along with the merge cells so I can adjust the code accordingly

Sure, I've attached the sample file "Sample_Find Duplicate"

I tried your option 2 and it worked on my sample sheet. However, I get Run Time error - 1004 Application-defined or object-defined error when pasted this code on my master report. I've attached the screenshot.

Forum page is loading perfectly for me

Thanks so much! The last version of code does the job.