As suggested by Nadine, name cell E3 on Sheet 2 as UserEntry.

< Put your cursor in Sheet 2 Cell E3. Name the cell by going to the upper
left of your screen until you see a white box with E3 and a drop down arrow.
Click inside the white box and name the cell - call it UserEntry from Nadine

Select all the cells in column C that need conditional formatting ie Sheet1
C2:C15000 (this will save having to copy the formatting later...)

With 'Formula Is' selcted copy the following in to the field:

=NOT(ISERROR(SEARCH(UserEntry,C2)))

Select the format required and then click OK.

Hope this was helpful.

Rik_UK

"tech1NJ" wrote:

I have 2 sheets with infomation. Sheet1 C2:C15000 have some text in each
cell. Some cells in C2:C15000 have the same text, or may have slightly
different text. Sheet2 E3 has a free text cell that my end users can type
into it at will. I like to turn the Cells C2:C15000 in Sheet1 to turn yellow
if the keyword in E3 is found within the text in C2:C15000 on Sheet1.
--
tech1NJ