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