you can use a formula to compare columns

C1 =A1=B1

will return 'True' if A1 and B1 are the same, or 'False' if A1 and B1 are
different

just copy the formula down as far as ness




"jillykate" wrote
in message ...

I am having a problem coming up with a conditional format to tell me
when 2 sets of data have changed.

For example, I have two columns, one with a ID number and the other
with a Letter. I want to compare it to another set of columns with the
same data and show me where the letter has changed for a particular ID
number. I would like have the changes highlighted.


--
jillykate
------------------------------------------------------------------------
jillykate's Profile:
http://www.excelforum.com/member.php...o&userid=33207
View this thread: http://www.excelforum.com/showthread...hreadid=530240