Hi
In column D I have a list of words and in column G each cell is full of sentences
I want to bold a word within the string that matches the word in the first column, it can be VBA or some sort of conditional formatting.
I thought conditional formatting first of all but could not think of a formula to work, so now thinking about the option of doing this with vba.
The word match should be case insensitive
here is basically the output I am looking for
[D1] -> Dog [G1] -> The man bought a dog on the weekend
[D2] -> Cat [G2] -> I would prefer to have a cat to a dog
[D3] -> Rat [G3] -> The rat ate the cheese
[D4] -> Pie [G4] -> For lunch I ate an pie
[D5] -> Job [G5] -> This is the best job I have ever had
In column D I have a list of words and in column G each cell is full of sentences
I want to bold a word within the string that matches the word in the first column, it can be VBA or some sort of conditional formatting.
I thought conditional formatting first of all but could not think of a formula to work, so now thinking about the option of doing this with vba.
The word match should be case insensitive
here is basically the output I am looking for
[D1] -> Dog [G1] -> The man bought a dog on the weekend
[D2] -> Cat [G2] -> I would prefer to have a cat to a dog
[D3] -> Rat [G3] -> The rat ate the cheese
[D4] -> Pie [G4] -> For lunch I ate an pie
[D5] -> Job [G5] -> This is the best job I have ever had