Conditional format - specific text

[Formula11]

Is it possible to format cells which contain specific text, for more than 1 instance.

Tried this with formula but no good.

=ISNUMBER(OR(SEARCH("test1",A1),SEARCH("test2",A1)))

 

[Peter_SSs]

Yes.
You would need to reposition the ISNUMBER as shown in column A below.
Or you could use the simpler formula as shown in column C.

23 06 04.xlsm
	A	B	C
1	abc		abc
2	test1		test1
3	This cell contains test2		This cell contains test2
4
5	test3		test3
6	*test1*		*test1*
CF

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C1:C6	Expression	=COUNT(SEARCH("test1",C1),SEARCH("test2",C1))	text	NO
A1:A6	Expression	=OR(ISNUMBER(SEARCH("test1",A1)),ISNUMBER(SEARCH("test2",A1)))	text	NO

 

[Formula11]

Thanks Peter, this works.

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.