Conditional Highlighting for two characters or more

[Double99]

I hope somebody can help me with two conditional format questions...

1. Can anybody please tell me what formula I need to type in to highlight all cells with two or more characters typed within them.

2. I also need a Conditional format formula that will highlight any cell with anything other than a number typed within it.

Many Thanks

Cris

 

[VoG]

Try

=LEN(A1)>=2

and

=ISTEXT(A1)

 

[T. Valko]

I hope somebody can help me with two conditional format questions...

1. Can anybody please tell me what formula I need to type in to highlight all cells with two or more characters typed within them.

2. I also need a Conditional format formula that will highlight any cell with anything other than a number typed within it.

Many Thanks

Cris

Try these...

1: =LEN(A2)>=2

2: =AND(A2<>"",COUNT(FIND(ROW(INDIRECT("1:10"))-1,A2))=0)

 

[T. Valko]

Try these...

1: =LEN(A2)>=2

2: =AND(A2<>"",COUNT(FIND(ROW(INDIRECT("1:10"))-1,A2))=0)

Note...

If you test formula 2 on the worksheet it has to be array entered.

I interpreted this:

any cell with anything other than a number typed within it.

To mean that a cell could contain a number like 10 or an alpha-numeric like AC 110.

 

[markmzz]

Or try this:

1. =LEN(A1)>0

2. =ISNUMBER(A1)=FALSE

Markmzz

 

[Double99]

Try

=LEN(A1)>=2

and

=ISTEXT(A1)

that worked brilliantly... thankyou for the speedy reply.