• 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

    Hui...

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

Conditional Formula

Matthew29464

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

Attachments

  • Conditional Formula.xlsx
    16.1 KB · Views: 8
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 ) ) )
 
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.
 

Attachments

  • Copy of Conditional Formula.xlsx
    16.2 KB · Views: 2
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.
 

Attachments

  • Conditional Formula (PB).xlsx
    11.5 KB · Views: 4
Last edited:
Back
Top