Highlight duplicate numbers with different colors in two columns

Hi, maybe that is incredibly easy, but I really don't know how to do it: I have two columns (D and F) with a quite big amount of numbers (almost 5000) and I would like each different duplicate to be highlighted in a different color, it's not important what kind of color though.
I already tried with Conditional Formatting, but it only uses one kind of color, so it's not right for what I'm asking.
As an example:

Please Login or Register  to view this content.

Again, the type of color is not really important, I just need them to be different for easily recognize the duplicates.

Thank you in advance.

Originally Posted by 17_types

Hi, maybe that is incredibly easy, but I really don't know how to do it:

Thank you in advance.

Hi. this is incredibly difficult, for doing using conditional formatting. You'll need 1 rule for eatch number!

Perhaps if you separate your numbers in categories...Or else, perhaps a VBA expert could be able to helps you.

Good luck.

Please Login or Register  to view this content.

after 56 colors it resets back to black and recycles colors....there are only 56 in the range
if cell is blank against blank it will highlight because they are counted as the same

here is link for step by step how to add macro should you need
http://www.contextures.com/xlvba01.html