Highlighting Multiple Duplicate Values - Different Color (For unique value more than 500)

[laam090]

I have more than 12000 row and have many text data, I want to highlight duplicate one with different color there are 545 unique values. What do i need to do? Please help

 

[SteveO59L]

try posting a sample of your data, and what you would like to do with it

 

[laam090]

I have a data like this
column 1 column 2 column 3
1
2
2
3
3
4
1
5
6
6
and i want to highlight(whole row) 1 with one color, 2 with other color, similarly other with other color, I found one macro but that gives only to 56 unique values 56 different color, but i have more than 500 unique values and total of 12000 row. can you help?

 

[SteveO59L]

I think to get >500 colours, the difference in shade would be so slight that you wouldn't be able to differentiate anyway

 

[laam090]

Ok that means there is no way, thank you for the response