Compare 2 columns and highlight adjacent rows that dont match

[gazmoz17]

Hi,

Is there a VBA solution for this.....been researching for a while & if anything topics I'm finding are more advanced than what I require ?.

Can use conditional formatting to highlight rows that don't match but wish for automated vba button click once my 2 column ranges are highlighted?

Or even more perfect if once conditional formatting is applied the entire spreadsheet is filtered on said formatting highlighting diffs?

Thank you

 

[jasonb75]

if anything topics I'm finding are more advanced than what I require

The most simple solution is to enter =A2=B2 into C2 (if column C is in use then go to next empty column). Fill down to the bottom of the data then filter the formula column to show FALSE only. No vba or conditional formatting needed.