Text within string, within a formula for conditional formatting

[MissH]

How can set up a rule in conditional formatting that is looking to a cell to contain text as opposed to equal text? e.g., If the cell ="apple", I can use =$A2="apple". BUT, if I want the rule to based on text within a string, eg, to format based on "apple pie", "apple tart", "baked apples", how do I do that? Can conditional formatting cope with find() or search(), and if so how to use it correctly?
I was hoping to use =A2=ISNUMBER(SEARCH("apple",$A2,1)) but that didn't work.

 

[Tetra201]

Try using just

=ISNUMBER(SEARCH("apple",$A2,1))

 

[MissH]

Thank you. I appreciate the help. That works to be able to highlight the individual cells.
My issue now is trying to apply formatting to the whole row based on the one cell, and the only way I know how to do that is to put in the extra "A2=", but maybe that isn't going to work here. Any tips to get the whole row formatted? If not, at least I have the one cell highlighted which is workable, so thank you.

 

[Tetra201]

Try using

=ISNUMBER(SEARCH("apple",A2,1))

Note: Cell A2 should be the upper-left corner of the conditionally-formatted range.

 

[Peter_SSs]

Welcome to the MrExcel board!

Not that important but you should not need the ISNUMBER function in your conditional formatting formula. Does this do what you want?

24 07 05.xlsm
	A	B	C	D
1	Text	data 1	data 2	data 3
2	apple	66	43	9
3	cherry	14	57	46
4	apple tart	76	39	10
5	baked apples	58	91	33
6	peach	90	96	60
7	peach pie	59	10	82
8	pineapple	63	80	6
9	banana	28	62	45
10	apricot	63	23	10
CF

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:D10	Expression	=SEARCH("apple",$A2)	text	NO