VBA Highlight Dupes in a Group

[PJ Karaffa]

I have data that is sorted in Column A by an ID number. Each ID number is duplicted multiple times and has data associated with it in column B. If in the duplicated ID numbers column B has duplicate value then highlight it.

Thanks in advance.

Dups in a group.xls

[kalak]

maybe

Please Login or Register  to view this content.

[Tinbendr]

Kalak, that's pretty cool. I'm going to have to spend some time studying Resize. I always forget about it.

Here's a long version.

Please Login or Register  to view this content.

[PJ Karaffa]

Thanks fellows for your help! Appreciate it!