Is there a way to autohighlight unique values in a list with unique colors?

So in the list:
cat same color as cat
dog same color as dog, but different from cat
hello and goodbye - unique colors

Yes, it is - Calc how to find multiple cells that repeat

that looks overly complicated .

You asked “Is there a way?”. I remembered that I had already walked this road and answered “Yes”. And showed that way. There went to duplicates. You need to go in the opposite direction, to the unique ones.

1 Like

Everything you need to solve the problem can be found on this resource - just use the search.
The solution uses code fragments published a long time ago: crtStylesIfNeed function and enumerating the cells of the selected range from a respected colleague @Lupp
MultyColorsForTexts.ods (12.8 KB)