Conditional Formula

[Matthew29464]

Please see attached file. I need a cell blacked out if another cell contains a key word. Thanks.

 

[Peter Bartholomew]

To test the data cell to see whether it contains 'Apple'
= ISNUMBER( FIND("Apple", data ) )
This may be generalised to test for a range of keywords {"Apple","Cherry","Lemon"} using
= OR( ISNUMBER( FIND(keyWord, data ) ) )

 

[Matthew29464]

Peter, I am not quite sure what to do with your formula. I'm using this rule in Condition Formatting =D2="Apple Pie". But this formula will only shade F2 if "Apple Pie" is in D2. I need a formula to look for the word Apple in D2 and shade F2 if the word Apple is in D2. D2 may contain Apple, Apple Sauce, Apple Juice, of Apple Pie. I've uploaded another spreadsheet showing the condition formatting I am using.

 

[Nebu]

Hi:

May be this?

Thanks

 

[Peter Bartholomew]

This is what I had.
It is the version that will format the cell if any keyword (Apple,Cherry,Lemon) is present in the string.
Adding or deleting terms from the keyword list changes the resulting format.

 

[Matthew29464]

Thanks for all your help.