auto hightlight text

tlyee

New Member
Joined
Oct 5, 2006
Messages
8
Hi everyone,

Greetings. Wondering if there is a way to highlight keywords that i want automatically in excel?

Currently I have some comment files and I would like to highlight some keywords in different color to spot for some trends.

For example, I would like to have the word "noise", "wait", "delay" or maybe more in green, yellow, and red.

How do I do that? Or if you have better suggestions to spot for trend that is even more fabulous!

Please educate.

Thanks in advance!
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Zack Barresse

MrExcel MVP
Joined
Dec 9, 2003
Messages
10,881
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
  3. Web
Hi there, welcome to the board!

I think you want to check out Conditional Formatting found under the Format menu. You can specify how you want cell(s) formatted (ie color, border, font, bold, italic, etc) if they meet a certain condition, maybe like having a certain word in it.

HTH
 

tlyee

New Member
Joined
Oct 5, 2006
Messages
8
Thanks Firefytr!

I tried the conditional formatting but it only happens if I have just one word in the cell.

My cells now contains phrases.

Say:

Cell A2 contains words "There is no delay"
Cell A3 contains words "We had to wait for long time to be discharged"
Cell A4 contains words "Somebody needs to explain why we are waiting"
Cell A5 contains words "No wait! Very quick!"

I would like to highlight the word "wait"

but the conditional formatting will not highlight any of the word "wait"
as they are in string / phrases.

It will change the format if the cell contains just the word "wait". No other words with it.

That's the part I have no idea how to make it happens. Am I missing something?

Hope it makes sense.

Thanks!!
 

fairwinds

MrExcel MVP
Joined
May 15, 2003
Messages
8,638
Hi,

With conditional formatting, you can use the "Formula is" option and the formula:

=ISNUMBER(SEARCH("delay",A1))

to search for a specific word in a sentence. However the whole cell will be highlighted, not just the individual word.
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,300
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

tlyee

The only way you will be able to highlight individual words in a cell would be using VBA.
 

tlyee

New Member
Joined
Oct 5, 2006
Messages
8
Ah... I see. Thanks! Hmm... Do you have any sites that you can recommend on vba coding particulary on this topic? I do not know vba :(

Thanks again!
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,300
Office Version
  1. 365
Platform
  1. Windows
tlyee

Eh, well if you want help with VBA you could start here.:)

I'm just off out the door so don't have time to post any code but I'll take a look later.

It might help if you can tell us the range(s) you want to look for these words.
 

tlyee

New Member
Joined
Oct 5, 2006
Messages
8
Thanks Norie!

I have a few sheets, different sheet has different range.

Let's just say, range E13: E 41

They all start with E13.

I can manage to change the range later in vba if needed, I think. I guess it shouldn't be hard to change the range?! :biggrin:

Thanks!
 

Forum statistics

Threads
1,136,370
Messages
5,675,369
Members
419,567
Latest member
Naveen27mech

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top