Hi Sybs,

Try the Compare addin, developed by Myrna Larson
and Bill Manville, which may be downloaded, free of
charge, from Chip Pearson's Downloads page at:

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


---
Regards,
Norman


"SYBS" wrote in message
...
Not sure if this Q should be in programming or Worksheets functions.
There
are 2 systems, (for double checking purposes) inputting data. The master
system will save the file as master.xls. The 2nd system will save their
file as compare.xls. It will then be compared to the master.xls for
accuracy, comparing the entries of each cell against each other in a
specific column. (The total column)

So for instance, master.xls, Sheet 1, range F10, should be the same as
compare.xls, sheet 1 range F10. If it is not the same I would like it to
be
highlighted in say red, on the master sheet

I have 12 separate sheets in the workbooks, and am looking for a simple
way
of achieving this, instead of just using the compare side by side on the
toolbar, which I don't think would highlight any differences. I have
looked
at compare.xla, but dont really know what I should be doing with it now I
have downloaded it, any help please

Be grateful .
Thank you

Sybs