How to highlight duplicate values ​​in cells with the same color?

Question

Google Sheets

You need to do this only for Google Sheets

Answer 1

If the values ​​are numeric, then you can make the conversion function number>>color and paint all cells.
Or:

1. go through the range
   
2. count matches
   
3. weed out single (or smaller thresholds)
   
4. assign colors
   
5. paint