Greetings All,
I'm looking for a VBA solution or function to help in this scenario. In A2 I have some text. I want to know if some of that text is in a long text string within B2. And if so, HIGHLIGHT that text so it is easily identifiable.
I'm looking for a VBA solution or function to help in this scenario. In A2 I have some text. I want to know if some of that text is in a long text string within B2. And if so, HIGHLIGHT that text so it is easily identifiable.
| SOURCE | FOUND |
| GRANNY SMITH APPLE | ORANGES, PEACHES, CRANBERRIES, FIGS, CHERRIES, WATERMELON, APPLES, GRAPES, BANANAS |
