mtahreemalam
New Member
- Joined
- Nov 18, 2019
- Messages
- 28
hey i tried both. only DanteAmor formula did the highlighting part but it was of the incorrect cells.
Since you are trying to match "WORDS" I think the previous suggestions will fail since they will match any substring rather than whole words. For example, I note that at least one of the suggestions highlights "headrest pillow" when column B contains neither "headrest" nor "pillow" (but does contain "pill", hence the substring match)match ANY WORD from the text string in column A.
Book1 | ||||
---|---|---|---|---|
A | B | |||
1 | TEXT STRINGS | Keywords | ||
2 | headrest tablet mount | Battery | ||
3 | headrest hooks | Alexa | ||
4 | headrest dvd player | xbox | ||
5 | headrest ipad holder | Décor | ||
6 | headrest tablet holder | pill | ||
7 | headrest pillow | tv | ||
8 | headrest covers for cars | jacket | ||
9 | same day | lotion | ||
10 | same day delivery | Rechargable | ||
11 | same pennis forever banner | playstation | ||
12 | peptides serum for face | decoration | ||
13 | peptides colagen | Thermometer | ||
14 | peptides for face | shirts | ||
15 | peptides powder | perfume | ||
16 | peptides serum | batteries | ||
17 | peptides cream | nintendo | ||
18 | peptides cream for face | gift | ||
19 | windbreaker men | mg | ||
20 | windbreaker women | hoodie | ||
21 | windbreaker pants men | deodorant | ||
22 | windbreaker jacket women | oil | ||
23 | windbreaker pants women | yoga mat | ||
24 | windbreaker jacket | soap | ||
25 | windbreaker pants | iphone | ||
26 | windbreaker mens jacket | lubricant | ||
27 | windbreaker women 80s | book | ||
28 | howard stern comes again | solution | ||
Sheet2 |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
A2:A228 | Expression | =LOOKUP(9E+99+307,SEARCH(" "&$B$2:$B$200&" "," "&A2&" ")) | text | NO |
BTW, when you report something like that, it gives helpers nothing to go on. Give some examples of what was highlighted when it shouldn't be and explain why or what was not highlighted and should have been and why. You need to help us help you.but it was of the incorrect cells.