Thread: condition formating
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK
 
Posts: n/a
Default condition formating
In the Formula Is panel of the Conditional Format, enter this:

=AND(ISNUMBER(B2),B2<50)

Hope this helps.

Pete

Reply With QuoteReply With Quote