test is text, not number..

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You probably want something like:

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

Hope this helps.

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

For CF, this might suffice:
=AND(A1<>"",ISTEXT(A1))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
Conditional Format Range of Cells 3
HOWTO: What is the formula to have evaluate a range of value 8
Conditional fomat series 2
If formula-different numbers entries 2
Creating sequential numbers plus a letter 4
Sum number range ignoring numbers formatted as text 0
When is text treated as number? 7

Back
Top