yogi_Conditionally Format Cell A2 If Phrase In Cell A2 Occurs Any Where in Column D of Sheet2

Google Spreadsheet   Post  #2076

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Oct-16-2016

question by: ed.W:

https://productforums.google.com/forum/#!topic/docs/rr8wpBHnnqU;context-place=forum/docs

conditional formatting: highlight cell if the text is contained in a range

It seems like I should be able to use a simple "Find" formula but it's not working.

Here's a sample sheet: https://docs.google.com/spreadsheets/d/1IyNGXg3ogHrIzsf_H2eonIHPpOULicG-T5ejPfWFJcU/edit#gid=1917666163

On Sheet1, I have a list of names. On Sheet2, I have a list of "phrases".

I'd like Sheet1, Column A cells to be highlighted if the contents appear in any of the phrases on Sheet2. I'm looking for  "partial matches", not exact matches.

I thought I could use something simple, like =find(A1,Sheet2!$A:$A) but that gives me an invalid formula error.

Can anyone help?

--------------------------------------------------------------------------------------------------------------------------