Use a macro ... There are 120 different three digit combinations that can be made from 10 digits,
without repeats, so you cannot have a unique color for each combination of digits. Do you only want
to highlight one at a time?

HTH,
Bernie
MS Excel MVP


"ghinzrey" wrote in message
...
Have created a three digit (including zeros) numerical database in the range
A2-A35 expanding now up to CC2-CC35. Note that leading zeros are not shown.
My wish is to find the cells of same numerics in any random or repetitive
(ex:567,576,657,675,756,765) in the whole database and to color shade. How
can I?