How can I compare two columns in Excel to highlight words that don't match?
- by Jez Vander Brown
(I'm using Microsoft excel 2010)
OK, lets say I have a list of phrases in both column A and column B (see screen shot below)
What I would like to happen whether it be with a macro, VBA or formula is:
If there is a word in any cell in column A that isn't any of the words in any cell in column B to highlight that word in red.
For example: in cell A9 the word "buy" is there, but the word buy isn't mentioned anywhere in column B so i would like the word buy to highlight in red.
How can I accomplish this?
(I think a macro/vba would be the best option but I have no idea how to create it, or even if its possible.)