Search and highlight hits only in Column C

Thank you Pete_UK. Does anyone have a suggestion for a macro that does the following:

1. Prompts the user for a word or phrase.
2. Searches only column C for the word or phrase.
3. Highlights in red all occurrances of the word or phrase in column C.

The attached file shows how something similar can be achieved with conditional formatting. Enter a keyword or phrase in cell K1 (yellow), and if it is found in column C the whole cell is highlighted. The CF condition in cell C2 is:

=ISNUMBER(FIND($K$1,C2))

which makes it case-sensitive (try "the" and "The" in K1). If case is not important then you can change FIND to SEARCH.

Hope this helps.

Pete