Can we compare two columns, and look for the inconsistent results?
Bow Arrow
Bow Arrow
Bow Arrow
Bow Silver
Sword Silver
Sword Silver
Sword Blue
Is there a way, Excel can tell me when the result for Bow is not Arrow and result for sword is not Silver and may be highlight that row or cell ??
Solved by V. W. in 25 mins