I can find all the duplicates in a column. Is there any way to make each duplicate numbers have a different color? I might have six H023558 eight H12581 two D012584 five H23698 etc...

I need to sort the rows by all the duplicates in groups and thought maybe if I could get them different colors then I could find a way to group the colors.

Thank you
Kim