Look to see if a cell contains something

[drewm]

Is there any way for one cell to look to seee if another cell contains something with a long string of text. I want to make a conditional statement that does one thing if a cell contains the word "drop", however the word "drop" may be within a sentence that will be several words long. The sentence length will vary. Is there any way to ferret out a single word?

 

[Mark W.]

=IF(OR(ISNUMBER(MATCH({"drop","drop *","* drop *","* drop"},A1,0))),"does one thing","does another")
This message was edited by Mark W. on 2002-04-22 06:20

 

[drewm]

=IF(OR(ISNUMBER(MATCH({"drop","drop *","* drop *","* drop"},A1,0))),"does one thing","does another")

Worked fantastic, thanks a lot!!!

 

[nisht]

Write down this code in selection change event of the sheet.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

If InStr(1, CStr(Target), "drop") Then
' code for conditional formating
Target.Interior.ColorIndex = 35
End If


i hope this will work.

ni****h desai
http://www.pexcel.com