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

	Column A	Column B	Column C	Column D
Row 1	Employee Number	Name	Position Title	Salary
Row 2	123	John	Operator	$50,000
Row 3	456	May	Manager	$100,000
Row 4	789	Dan	Administrator	$45,000
Row 5	1011	Judy	Analyst	$80,000

<tbody>
</tbody>

Sheet 2

	Column A	Column B	Column C	Column D
Row 1	Employee Number	Name	Position	Salary
Row 2	333	Beth	IT Analyst	$90,000
Row 3	789	Dan	Senior Administrator	$70,000
Row 4	123	John	Operator	$50,000

<tbody>
</tbody>

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!