Hi guys
I have a sheet with a long list of words and output from another source
I need help to have excel show me anything I need to pay particular attention to.
SO in column A, I have the word unt but in column H, I have text as part of sentences such as bunting, hunt etc.
I want a conditional formatting that says in column A, anything with a full word match to the phrase in column H should be highlighted. There are no full word matches in my example but I am future proofing this.
Please help and advise thank you!
Bookmarks