In an Excel 2010 worksheet I use three columns. I need a user to be able to input a word or phrase into a cell or input box, and have Excel highlight that word or phrase every place it occurs only in column C.

Can I do that with conditional formatting? Or do I need to use a function? Or do I need a macro? I've tried Googling and can't find a good solution.