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

  • Thread starter Thread starter Max
  • Start date Start date
M

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
 
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.
 
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.
 
Dave,

That works fine.

Many thanks
Max

Dave Peterson said:
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.
Click to expand...
 
Back
Top