Excel VBA - Comparing two columns of data

[DragonL]

I am using Excel 2002, and I am trying to create a macro to compare tw
columns of data and highlight or shade the cells or colorize any entr
that is not in both columns.

I also read something about being able to put a button on the exce
chart that runs the macro. Could someone help me with that too? :

 

[Dave Peterson]

Chip Pearson has lots of ways to compare two lists.

Some are macros and some are worksheet formulas.

http://www.cpearson.com/excel/duplicat.htm

(I'm not sure I'd start with code. Learning the formula technique may be much
more useful.)