Need some help BAD with conditional formatting
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
|