Triple Number
 

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

Triple Number
 

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

Triple Number
 

Or perhaps a custom number format of...
[Black][<=99]General;[Red][<1000]000;0;@

Also, I think Dana meant Conditional Format not custom format.
--
Jim Cone
Portland, Oregon USA



"smandula"
wrote in message
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

Triple Number
 

Hello,

I suggest the conditional format (formula)
=AND(A10,A1<10,MOD(A1,111)=0)

Regards,
Bernd