"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?
|