• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional Formula

Peter Bartholomew

Well-Known Member
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 ) ) )


New Member
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.