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 dont 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