Basically I'd like to highlight all duplicate cells with duplicate values. I've used conditional formatting to do this. The twist is, I would like each different, duplicate value to be highlighted a unique color.
For example, If apple was found in three different cells, highlight them all red. If orange was found in two different cells, high them all blue etc. etc. and this will go on for hundreds of different, duplicate values... So I need it to generate slightly unique colors as well.
Any ideas? Thanks!
EDIT: I found a solution at this website: https://www.extendoffice.com/documents/excel/3772-excel-highlight-duplicate-values-in-different-colors.html although it costs money to install, this module, so if anyone has a different solution it would be greatly appreciated.