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