Hello,
I am trying to do Conditional Formatting > Highlight Cell Rules > Text that contains -- but for multiple words at once.
I have a list of seed words in A1 to A96
I have my main list of words in B1 to B17582
I want to highlight all traces of seed words in main list
Welcome to the forum!
Use this formula CF rule:
=B1=VLOOKUP(B1,$A$1:$A$96,1,0)
and set it to apply to the range $B$1:$B$17582.
This will highlight cells that match any in the list:
Excel 2016 (Windows) 32 bit
one one five two seven thee none four five six seven eight nine ten
Sheet: Sheet1
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
If the seed word(s) could appear anywhere within each cell in the main list of words, try this
Select the range B1 to B17582
then apply this formula for the Conditional Formatting:
=SUMPRODUCT(ISNUMBER(SEARCH($A$1:$A$96,B1))*($A$1:$A$96<>""))>0
------------- ----------
Any good? Hit the star at the bottom left
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks