How to check digits of a number

**bebo021999** · 10-23-2020, 09:48 PM

With number in A1

This returns TRUE/FALSE, use it for conditional formatting

=AND(MID(A1,ROW(INDIRECT("2:"&LEN(A1))),1)-MID(A1,ROW(INDIRECT("1:"&LEN(A1)-1)),1)>0)

Array formula, confirmed with Ctrl-shift-enter

**hrlngrv** · 10-25-2020, 04:28 AM

Originally Posted by bebo021999

. . .

=AND(MID(A1,ROW(INDIRECT("2:"&LEN(A1))),1)-MID(A1,ROW(INDIRECT("1:"&LEN(A1)-1)),1)>0)

Would return an error when A1 has just 1 numeral, in which case INDIRECT("1:"&0) would be the cause.

Re: How to check digits of a number