"Contains" in conditional formatting

[Mark]

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?

 

[Bob Phillips]

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)

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?

 

[Frank Kabel]

Hi Mark
enter the following formula in the conditional format dialog
=ISNUMBER(FIND("msg",$A$1))
and choose your format

Frank