Please help with a VBA code.
I want to compare two columns with many many items.
I need to highlight the items from column A that have more than one DIFFERENT match in the column B.
In my attached EXAMPLE file:
Apples are always red, oranges are orange and mango are yellow. Such cases would not trigger "the alarm".
Same case with the strawberries. Since it is only one match in the other column, would assume it is correct (all strawberries are red).
In case of the bananas (or the kiwi), there are more than one (color) match for them in the other column. These are the cases that require my attention and need to highlight them.
I don't know if my problem can be solved easier with some rule in conditional formatting or Excel functions and not a VBA code. Thank you in advance for any help!
Bookmarks