test is text, not number..

[nastech]

hi, trying to fix a conditional format to if not empty, but not a number. is
there a way to test for that? along lines of:

=IF(AND(A1<>"",A1<>number),..

thanks.

 

[Pete_UK]

You probably want something like:

.... NOT(ISNUMBER(A1)) ...

Hope this helps.

Pete

 

[Max]

=IF(AND(A1<>"",A1<>number),..

For CF, this might suffice:
=AND(A1<>"",ISTEXT(A1))