Triple Number

  • Thread starter Thread starter smandula
  • Start date Start date
S

smandula

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
 
Perhaps try a custom format with the equation:

=Mod(Number,111)=0

= = =
Dana DeLouis
 
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" <[email protected]>
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
 
Hello,

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

Regards,
Bernd
 
Back
Top