So in the list:
cat
cat
dog
dog
hello
goodbye
.
cat same color as cat
dog same color as dog, but different from cat
hello and goodbye - unique colors
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)