Thread: conditional format formula
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave O Dave O is offline
external usenet poster
  
Posts: 427
Default conditional format formula
Here's one way:
=IF(AND(NOT(ISNUMBER(FIND("-",A1,1))),NOT(ISNUMBER(FIND("0",A1,1))),NOT(ISNUMB ER(FIND("
",A1,1)))),B1,"")

Reply With QuoteReply With Quote