Conditional Formatting/ Formula is: =A1<B1
Set your desired format

Or (to format cell B1), Conditional Formatting/ Cell value is/ Not equal to:
=A1
--
David Biddulph


"lputnam" wrote in message
...
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.