Put your cursor into Sheet 1 Cs. Go to Conditional Formula, and choose is
equal to and then move to the next box and type in =$E3. The choose Format
and choose yellow on the Patterns tab. Copy and paste this all the way down
to C15000.
Nadine

"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