Need to bold a cell based on keyword in another cell...

[Max]

Hello,

I need to figure out how to bold the contents of cell S2 if a key word is
present in cell W2. The key word is "resolution". But there may be many words
in cell W2

Any help is appreciated.
Regards

 

[Mike H]

Hi,

Apply a conditional format formula to S2

=ISNUMBER(SEARCH("Resolution",W2))

I assume e2003 to do this

Format-Conditional format - Select formula is and enter the formula above -
Format tab - Fonts tab and select BOLD
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

 

[Dave Peterson]

Select S2
Data|Conditional formatting (in xl2003 menus)

Formula is:
=search("resolution",w2)

Conditional formatting will treat an error (if it's not found) as false.

 

[Max]

Dave,

That works fine.

Many thanks
Max

Select S2
Data|Conditional formatting (in xl2003 menus)

Formula is:
=search("resolution",w2)

Conditional formatting will treat an error (if it's not found) as false.