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:
Again, the type of color is not really important, I just need them to be different for easily recognize the duplicates.Please Login or Register to view this content.
Thank you in advance.
Bookmarks