Multiple occurrences of duplicate

I do not know how many possible occurrences you expect. For few (10-15 max) is make sense with Conditional Formatting like below:

Capture.PNG

For each number here

Please Login or Register  to view this content.

set different colour.

For more I think solution with VBA make more sense.