Sometimes the simplest problems are the hardest. I'm comparing an updated
spreadsheet (25 col, 3000 rows) to a prior version. Prior version included
color coding reflecting audit status. Would like to transfer the color
coding from the old to the new were the data is unchanged.

In Excel 2000, how can I accomplish the following:
If value in cell A = value in cell B, copy format (cell color) of cell A to
cell B.

Macros ok, VBA ok. Thanks in advance for any assistance.

JamesB