Hi-

I am trying to format a file, which has a list of data that is grouped based on an ID code.

Ex.


001 James
001 Jenny


002 Jimmy
002 Connor

003 Steven
003 Sean
003 Jan

004 Danny
004 Grant

The duplicates would be identified based on their ID# number (ex. 001) and every other set of duplicates needs to be highlighted. Ex. so the 001 & 003 data sets would be highlighted but not the 002 data set.

I am not too familiar with VBA coding, is there a function or set of functions that would allow me to format the data based on the criteria described above?