View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default test is text, not number..

You probably want something like:

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

Hope this helps.

Pete

On Jul 14, 1:32 am, nastech wrote:
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.