Excel Text Search In List

This project was awarded to koolsidz for $35 USD.

Get free quotes for a project like this
Project Budget
$30 - $250 USD
Total Bids
Project Description

I need a formula to do the following;

I have a column of sentences in cells b2:b600000.

I have a list of words in cells c2:c20.

I want a formula to highlight the cells (in colour) in column b that contain the words in column c. The words in column b may be in sentences.

I can't seem to get my head round it although I am sure it will be a very quick job for the right person.

I need this really urgently please.

Any questions just ask!


Awarded to:
Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online