Conditional Format - 2 or more letters but not numbers

[Double99]

Hi,

I wondering if someone could help me.

Is there a conditional format that will highlight a Cell that has two or more letters within it, but NOT numbers.

Example...

Letter 'A' - No format
Letters 'AS' - FOrmat
Number '1' - No format
Number '11' No format

I know the Formular for two or more characters [=LEN(A1)>=2] but I'm not sure if you can define the difference between numbers and letters.

Many Thanks

Cris

 

[Norie]

How about the ISTEXT function?

Combine that with LEN, and you get:

=AND(ISTEXT(A1),LEN(A1)=2)

That will check A1 is text and has 2 characters.

Doesn't take into account numbers entered as text or the case of the letters.

 

[moonfish]

This works for me:

=AND(AND(ISERROR(SEARCH({1,2,3,4,5,6,7,8,9,0},A1))),LEN(A1)>=2)

EDIT: This applies no format to "A2B" because it contains a number. I assumed that this is your intention, let me know if it's not.