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
Bookmarks