View Single Post
  #2  
Old February 6th, 2004, 07:23 PM
Bob Phillips
external usenet poster
 
Posts: n/a
Default "Contains" in conditional formatting

Mark,

Yes, use a formula like

=NOT(ISERROR(FIND("msg",A1)))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Mark" wrote in message
...
Is there a way to set conditional formatting to respond when a cell

contains the text "msg" somewhere in the body of text in that cell?