keyword search - a macros to change font color for specific key words (not entire cell)

Hi,

so my issue is this: i need to conduct keyword searches in excel and color the keywords a different color without changing the font color of the entire cell. now, i found some code from another thread that does this, but i cant seem to get it to work with more than 2 keywords. i need some help fine-tuning the provided code to do what i need it to do.

please see: http://www.excelforum.com/excel-gene...ain-color.html

the VBA code i used was this:

Please Login or Register  to view this content.

i was playing around with the example, the Cat_Mouse.xlsm, and when i modified the 'myList' and 'myColor' arrays, it does not work.

Cat_Mouse.xlsm

for example, i modified the code to add the word bat:

Please Login or Register  to view this content.

when i run the macros, the word "Bat" does not become colored red. interestingly enough, when i substitute the word "bat" for the word "hat" in the "myLIST array, the word "hat" does change to the red font. any ideas on why this is happening?

i am looking to use this code to address keywords in my excel file by coloring all key words red and i have more than 10 key words.

any help would be appreciated, thanks.

excellent find, stanleydgromjr!

i decided to use this code:

Please Login or Register  to view this content.

my question is how do i edit this code to work not only in column B but also column H (ie, look for all keywords in columns B and H)

would be really nice if i could figure out a way to modify this code to fit my needs. this code should alow me to paste my keywords in a separate sheet

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Originally Posted by jindon

Please Login or Register  to view this content.

hi Jindon,

thanks for your response. if i use that code, i still cant add more than 2 keywords to be searched. any ideas?

You should be able to add as many as you want.

e.g

Please Login or Register  to view this content.

how do i modify the code so that if my keyword was "cat" and my spreadsheet had the word "Cats" that it would show up as Cats

Try change the pattern to

Please Login or Register  to view this content.

This macro was created to format substrings in a selected range of cells in a single step:

hi,how to extract the highlighted keywords(e.g. cat,mouse) in the column J?
For example:
Column B Column J
Cats123 Cat
002Mouse123 Mouse
Mickey Mouse Mouse

Regards