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

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

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

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.


"Max" wrote:

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

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

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 wrote:

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

--

Dave Peterson

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

Dave,

That works fine.

Many thanks
Max

"Dave Peterson" wrote:

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 wrote:

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

--

Dave Peterson
.