VBA to change the color of a word if it appears.

[handysmurf]

just the word (or string) itself, not the background and not all the words in the cell. This would be based on a list of words that appear in column FD. In some cases it would be several words together such as "head up your ***". Most are just one word. Its fine if it just works on the entire sheet and I want them to be bright red FF000 and bold. Also, in one case, what I'm looking for is "pos" ... which appears in many words but I only want it to highlight if it stands alone.

I've found some similar threads but I don't know enough about VBA to make the changes necessary to do what I need.

Thanks in advance

 

[handysmurf]

 

[handysmurf]

Ok ... I've been playing around with it .... it is working. It is very picky but that is ok now that I have figured it out.

I want to run this when I save the workbook. I tried to do a sub to set the range it looks in, which worked. I tried to do a sub to run the "setrange" then your formatting sub. I broke it and had to back peddle.