Conditional Formatting with text

  • Thread starter Thread starter excelmedia
  • Start date Start date
E

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

:
 
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)
 
Bob said:
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.
Click to expand...

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

Frank
 
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
 
Gord,

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

Bob
 
Back
Top