Finding the difference between two excel sheets - Conditional formatting and Vlook up

[jckiddo]

Hi there,

I require assistance in being able to determine the differences between two excel spreadsheets.

I have a bunch of data in Sheet 1 and these data has been altered and saved in Sheet 2. Now, I would like to be able to highlight in Sheet 2 which cells have been altered. The main point of reference in both sheets are the data in Column A. However, the data in Column A in both sheets are not all the same (e.g. Sheet 2 may have had additional data or removed data from Sheet 1).

Is there a way to use Vlookup and Conditional formatting, to pin point in Sheet 2 which cells have been altered from Sheet 1?

See below example of my ideal result:

Sheet 1
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD][/TD]
[TD]Column A[/TD]
[TD]Column B[/TD]
[TD]Column C[/TD]
[TD]Column D[/TD]
[/TR]
[TR]
[TD]Row 1[/TD]
[TD]Employee Number[/TD]
[TD]Name[/TD]
[TD]Position Title[/TD]
[TD]Salary[/TD]
[/TR]
[TR]
[TD]Row 2[/TD]
[TD]123[/TD]
[TD]John[/TD]
[TD]Operator[/TD]
[TD]$50,000[/TD]
[/TR]
[TR]
[TD]Row 3[/TD]
[TD]456[/TD]
[TD]May[/TD]
[TD]Manager[/TD]
[TD]$100,000[/TD]
[/TR]
[TR]
[TD]Row 4[/TD]
[TD]789[/TD]
[TD]Dan[/TD]
[TD]Administrator[/TD]
[TD]$45,000[/TD]
[/TR]
[TR]
[TD]Row 5[/TD]
[TD]1011[/TD]
[TD]Judy[/TD]
[TD]Analyst[/TD]
[TD]$80,000[/TD]
[/TR]
</tbody>[/TABLE]











Sheet 2

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD][/TD]
[TD]Column A[/TD]
[TD]Column B[/TD]
[TD]Column C[/TD]
[TD]Column D[/TD]
[/TR]
[TR]
[TD]Row 1[/TD]
[TD]Employee Number[/TD]
[TD]Name[/TD]
[TD]Position[/TD]
[TD]Salary[/TD]
[/TR]
[TR]
[TD]Row 2[/TD]
[TD]333[/TD]
[TD]Beth[/TD]
[TD]IT Analyst[/TD]
[TD]$90,000[/TD]
[/TR]
[TR]
[TD]Row 3[/TD]
[TD]789[/TD]
[TD]Dan[/TD]
[TD]Senior Administrator[/TD]
[TD]$70,000[/TD]
[/TR]
[TR]
[TD]Row 4[/TD]
[TD]123[/TD]
[TD]John[/TD]
[TD]Operator[/TD]
[TD]$50,000[/TD]
[/TR]
</tbody>[/TABLE]









Sheet 2 contains the new data, and from the example above I would like to be able to highlight what has been changed from Sheet 1 by using Column A as the reference. In this example, the C3 and D3 of Sheet 2 have been highlighted (font turned red). Ideally, I would like to be able to change the colour of the cell for easier visual reference.

The data I have is obviously a lot bigger than these, so it would be great if someone could provide me with some assistance on how I can apply a formula or vlookup or conditional formatting to apply on the spreadsheet.

Thank you!