Perhaps try a custom format with the equation:

=Mod(Number,111)=0

= = =
Dana DeLouis


smandula wrote:
Is there a way to identify triple numbers in a column
and change that cell to red

i.e. triple number (111 333 777 etc.) change cell to red