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
Dear Hiring Manager,
I want to do this "Excel Text Search In List" project now, let's start immediately. I have read the job description. Please send me the excel and more details of the job.
Regards,
Oliver
Gold freelancer UK based; 2:1 BSc hons degree; 10years ms office experience advanced word and excel; audio typing experienced as medical secretary for head of departments. 60 wpm typing speed. Reliable; 10/10 freelancer feedback; ready to start asap, good communication and fast turnaround - please PM further info
Hello There
I am interested to do the job. Since I meet all the experiences and skill conditions. I assure you Sir, that, I selected I shall do my work most conscientiously.
Thank you
G Sarker