I need to compare cells 2 columns and return a value if different.
e.g.
A1: 2002 B:2002
A2: 2002 B:2003
A3: 2002 B:2002

Need to identify row 2 is different (with an x and a color?) I have about
1000 rows to compare.
I tried some of the formulas listed in this section e.g.
=if(countif(a:a,a25)1,a25,"")
but didn't return what i wanted.