Prev: Doing a countif against a substring of the range to be scanned
Next: how do I create independent results?
From: Rik_UK on 29 Mar 2010 20:20
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
First  |  Prev  | 
Pages: 1 2
Prev: Doing a countif against a substring of the range to be scanned
Next: how do I create independent results?