• 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.

Custom Search

E

elsmith9035768

Member
I download comments into cells and need to search the cells for certain words or phrases. From what I can find online, if I search for a word or phrase, I must limit the search to one search at a time and the search result is either “True” or “False”. The attached spreadsheet is an example with two separate approaches. The second is preferable, but I don’t know if it is possible. There will be 10 to 20 comments in column I. This is a template, so I will be adding key words and phrases over time. Thanks.
 

Attachments

  • Search Example.xlsx
    10.6 KB · Views: 5
First approach can be implemented through formula based conditional formatting. See attached file.

To implement in cell D7, I have applied following formula in conditional formatting:
=ISNUMBER(SEARCH(D$7,$I8,1))
And then copied across for cells required.

Second approach is also doable but it will require VBA.
 

Attachments

  • Search Example.xlsx
    10.7 KB · Views: 9
You must log in or register to reply here.
Back
Top