Personally I'd do it with conditional formatting to highlight the
differences between the 2 sets of data.

Go in to cell D2, then choose Conditional Formatting from the Format
Menu bar

Under Condition 1 choose "Formula is" and then type

=IF(A2<D2,TRUE,FALSE) in to the box on the right.

Click Format and choose how you want to highlight the differences (eg
in red text).

Then click Add

This will compare cell D2 to cell A2 and if they are different then D2
will show in a different format

And if you Format Copy that cell to your other ranges it'll do the
rest.

Hope that makes sense?

Lee



--
roundabout
------------------------------------------------------------------------
Posted via http://www.mcse.ms
------------------------------------------------------------------------
View this thread: http://www.mcse.ms/message2425323.html