krs

I have two Excel spreadsheets (Excel 2004), actually workbooks, but that doesn't matter - I can compare thyem sheet by sheet.

Seems I may have made updates to an earier version not realizing there was already a later version with different updates.

So now I want to find the differences between these two versions to create an update that includes all the changes from the last two versions.

There seem to be lots of Windows applications that do exactly that but for the Mac all I find is workarounds by using MS Word or trying formulas within Excel.

Any simple foolproof fast way to just highlight the differences for the Mac?

WCraig

Create a third workbook and use the equal operator to compare each corresponding cell; see the following formula:

=[Workbook1]Sheet1!A3=[Workbook2]Sheet1!A3

Use Conditional Formatting to dim the cells containing the value for 'true' since we don't care about these ones. See the attachment below. (I'm using Excel 2011 so the window looks different but the concept is the same.) Any cell that contains the 'false' value will give you a pointer to the changed values.

Before you copy and past the formula, watch out for absolute references ($A$3) which is what Excel will default to if you point and click between the workbooks.

Craig

Attached Images

Conditional formatting.jpg (42.1 KB, 5 views)

krs

Thanks for your help Craig.

I don't really feel that comfortable with Excel to try what you suggested.
Tried it on just two of the worksheets, but even with that I'm not sure I have everything set up correctly.

But then, more by luck than anything, I camer across this Excel comparison tool.
Did the job for me:

Compare two Excel spreadsheets without programming macro nor installing software on your computer