I have a whole column filled with data, ranging from about 100-500 rows of data depending on the day. Sometimes duplicates happen, and I need to know about it. What I am hoping to do, is look for duplicates, but format different duplicates differently.
ex)
889546
446533
889546
25846
2156
25846
If it is possible to highlight all 889546 cells one color and 25846 another color etc. As I understand, colorindexing is done by numbers, is it possible to loop through this as well?
Bookmarks