Sunday, October 16, 2016

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   Oct-16-2016
question by: ed.W:!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.

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?