Excel Text Search In List

IN PROGRESS
Bids
21
Avg Bid (USD)
$43
Project Budget (USD)
$30 - $250

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!

Sheridan

Skills required:
Data Processing, Excel
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 30
in 1 days
Hire schandraram
$ 40
in 0 days
$ 35
in 0 days
Hire northwolves
$ 30
in 0 days
$ 30
in 0 days
Hire manishadk
$ 35
in 1 days
$ 30
in 0 days
Hire sujiumesh
$ 30
in 1 days
$ 30
in 1 days
Hire drchaz
$ 40
in 1 days