Comparing Lists in Excel 2003

Hi Guys

I have a workbook, with sheet 1 and sheet two. They both contain same amount of data and would like to compare the values on each to make sure they are the same.

For example:

Sheet1

A
-----
1234
1243
3245
5445

Sheet2

A
-----
1234
1243
3245
5445

Is there a formula that can compare these values and return "all match" if they all match and "different" if there is one or more that don't match. Also, is there a way of color coding the one that doesn't match?

Ideally I would like the result to be displayed in one cell, so its easy to evaluate. (for example, if im comparing 3000 records, I can see that this one cell says "all match" and I dont have to look through the entire sheet)

Any help would be much appreciated.

Nish