Thread: test is text, not number..
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nastech nastech is offline
external usenet poster
  
Posts: 383
Default test is text, not number..
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.
Reply With QuoteReply With Quote