vba - compare 2 columns highlight data not common to both

hi all

Looking for some code to do a simple compare column A to Column B (row 1 contains headings) and highlight any differences.

cheers

Please Login or Register  to view this content.

or something similar.

Edit: just re-read your post, that will highlight anything in column A that is not present anywhere in B and vice-versa, if you just want to compare row against row then use conditional formatting and something like:
=$A2<>$B2
as the formula

U can use this