Hi Guys,
I am familiar with "conditional formatting" for single words using "text that contains".
But what if I have multiple words I want to check for, is there an easier way to do it, or do I have to put each one in separately?
Doing that one by one takes too much time...
Thanks
Sami
Could you give a few samples of what you are working with?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Sure,
For example, lets say that I have a single column and many rows.
Each row has only text in it.
Something like this:
Can you get lice from buying a flat iron from Goodwill?
Could you help me get rid of lice PLEASE?
can one purchase crab lice?
friends help: how can you get body lice?
OMG! LICE! help.. are there any natural products?
Where could you go to get head lice out and how much would it cost?
Head Lice--Can You Help Your Child Avoid It?
Are there any home remedies for head lice on furniture carpet etc?
Are there any lice free treatments without a comb?
Are there any remedies for head lice?
Are there lice eggs in Dr. Pepper?
Are there signs of lice if so what are they <3?
Can one nit cause lice?
Can you shower right after you have a de-lice treatment?
Can you use lice treatment to get rid of fleas?
Could you get head lice from fleas?
Could you get lice from a racoon that has been dead for several days?
How can one person only get one lice bug?
How far can a lice bug jump to its next host?
How far can lice jump?
How far can lice jump from human to human?
How far do lice and fleas jump?
How many different species of lice are there?
I would like (using conditional formatting) to highlight only the rows that has ANY of the following 3 words: lice, far, can
I would like to somehow do this for all 3 words (lice, far, can) at once.
Any ideas?
Hello sami770,
Please try the attached sample Workbook.
Regards
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
hi Sami. what if the sentence contains something like:
call the police
if that is not supposed to be higlighted & you're very sure there are no such cases, select the range you want to apply to (say from A1:A10)
go to Home -> Conditional Formatting -> New Rule -> Use a formula to determine which cells to format -> Format values where this formula is true:
=SUMPRODUCT(--(COUNTIF(A1,"*"&$D$1:$D$3&"*")))
D1:D3 is assumed to contain the 3 words
if there are, you might have to provide the possible symbols you would have (like ?, !, & - i see in your file) to do a formula. if it's too many, you may have to resort to VBA (something i might not be able to help).
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Thank you for your help!
Originally Posted by Winon
That's EXACTLY what I need, thanks a lot!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks