This utility colors the repeated values in your selection.
Each set of duplicate values is given its own unique color. This helps you quickly find repeated values by having a set of colors that are each easily distinguishable from one another.
For example, if your selected range contains 5 cells with the value "Montreal", then those 5 cells will have the same color, such as yellow. And if the value "New York" exists in 2 cells, then those 2 cells will also have the same but different color, such as green.
This utility is case-sensitive, which means, for example, that
Marking duplicates is the reverse process of marking cells with unique values .
Click
This utility uses 16 different colors to indicate each set (groups) of duplicates. If the number of groups exceeds this number, this tool will reuse the set of colors.
Using this tool, you are guaranteed to save time and effort. However, the actual time savings depends on how often you use LibreOffice Calc, the amount of data you work with, and how often you use the tool.
If you don't already have YLC Utilities, you can download the free version "YouLibreCalc.oxt" or the full-featured version "YLC_Utilities.oxt" .