View Single Post
  #3  
Old February 6th, 2004, 07:24 PM
Frank Kabel
external usenet poster
 
Posts: n/a
Default "Contains" in conditional formatting

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

Frank

Mark wrote:
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?