Conditional Formatting with text

[excelmedia]

Hello

This maybe really simple...but here goes.....

I need to change the format of either the cell or the row within
table only if the cell contains the text "ball". Now the cells woul
have a whole phrase like "the ball is red" . But as long as it has th
word ball I need it highlighted.

Please help

:

 

[Bob Phillips]

You need to have a condition of FormulaIs, and a formula of
=NOT(ISERROR(FIND("ball",A1)>0)). Just set the pattern colour and you are
away.

--

HTH

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

 

[JE McGimpsey]

one way:


CF1: Formula is =COUNTIF(A1, "*ball*")

 

[Frank Kabel]

You need to have a condition of FormulaIs, and a formula of
=NOT(ISERROR(FIND("ball",A1)>0)). Just set the pattern colour and you
are away.

Hi Bob
or a small simplification
=NOT(ISERROR(FIND("ball",A1)))

Frank

 

[Bob Phillips]

Frank,

Good, but not good enough! Have you seen John's solution?

Bob

 

[Frank Kabel]

Frank,

Good, but not good enough! Have you seen John's solution?

Bob

John's is definetly better!

Frank

 

[Gord Dibben]

Select the cell(s) or row(s) to format.

Format>CF>Formula is: =IF(COUNTIF(A1:A1,"*ball*"))

Pick a color from Format>Patterns and OK.

Gord Dibben Excel MVP

 

[Bob Phillips]

Gord,

As John shows, you don't need the IF, as it can only return 0 or 1, Excel
False or True

Bob