Simplest method - won't give cell color, but rather word color.
Use Replace to find the target word and replace with the same word applying color and/or text shading.
You can get to the formatting options by clicking More on the Replace dialog.
Anything else will require a macro.


If you want a volunteer here to write a macro for you, I would suggest that you attach a sample file so they will not have to try to recreate your situation to give you a fix.