Match partial word instead of all or nothing

Hi there! I was looking at what is now a closed thread here, and found this lovely bit of code. The only problem I've been having with it is that it changes the font of only an exact word but if the word is part of another word the macro won't touch it. Eg if a cell contains "I have a cat" it will change to "I have a cat" but if the cell contains "I have cats" it will remain "I have cats". How would you modify this code so that the word's font will change even if it is contained within another word: "I have cats"

Please Login or Register  to view this content.

I tried modifying a bunch of stuff on line:

Please Login or Register  to view this content.

but nothing seemed to work. Any help would be greatly appreciated!

Yeah, that's what I was kind of concerned about doing. I'd be okay with a solution that did highlight the entire word, like category though. But I'll consider adding extras to the mylist (and mycolor) line as you suggested, thanks!