Hello,

I've tried a few different ways and I've done my searching on the internet, but I still can't find code to get this to work. I'm trying to highlight rows if there is more than one instance of column A and B.

I've attached a sample document of my data. The first 11 rows is what I'll start with, and rows 20-30 is what I'd like it to look like in the end. You'll see that the rows are only highlighted if there are multiple accounts of rows where column A and B are duped.

Also, I realize this can probably be done without VBA, but its part of a bigger macro so thats why I'd like to keep it VBA.

Let me know if you have any questions.

Thanks!

DuplicateHighlightTest.xlsm