Conditional Formatting based on substring -in the same column-

[DisceCogetare]

It's a common and simple question/answer to run Conditional Formatting due to a substring based on a string/cell outside of the column.
But how would I accomplish this within the column? Obviously I'd have to account for Cell <> Itself, but I can't even get the first half to work yet.
Long story short, I want to notify someone visually if they happen to add an entry to a list which happens to be contained in something else in the list.

	A
1	Jump	Highlight A1 because Search(A1,A2)
2	Jumping Jacks
3	Jumping Around
4	Run	Highlight A4 because Search(A4,A5)
5	Eating prunes
6	Ping	Highlight A6 because Search(A6,A2)

First post, be gentle?

 

[bebo021999]

=COUNTIF($A$1:$A$6,"*"&A1&"*")>1

 

[Peter_SSs]

Welcome to the MrExcel board!

Here is another option.

22 01 27.xlsm
	A
1	Jump
2	Jumping Jacks
3	Jumping Around
4	Run
5	Eating prunes
6	Ping
CF strings

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:A6	Expression	=COUNT(SEARCH(A1,A$1:A$6))-1	text	NO

 

[DisceCogetare]

Thank you both, I hadn't considered wildcards or just counting the number of hits on a search.

 

[Peter_SSs]

You're welcome. Glad we could help. Thanks for the follow-up.