G Guest Feb 6, 2004 #1 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?
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?
B Bob Phillips Feb 6, 2004 #2 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 said: Is there a way to set conditional formatting to respond when a cell Click to expand... contains the text "msg" somewhere in the body of text in that cell?
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 said: Is there a way to set conditional formatting to respond when a cell Click to expand... contains the text "msg" somewhere in the body of text in that cell?
F Frank Kabel Feb 6, 2004 #3 Hi Mark enter the following formula in the conditional format dialog =ISNUMBER(FIND("msg",$A$1)) and choose your format Frank
Hi Mark enter the following formula in the conditional format dialog =ISNUMBER(FIND("msg",$A$1)) and choose your format Frank
