Identifying different cell values VBA

[JoeRooney]

Hi, <o></o>
<o> </o>
Wondering if someone could assist me with some code to identify cell differences in a spreadsheet.<o></o>
<o> </o>
I need the macro to highlight the cells that have the samefirst name in column A and different values in the direct cell below in column .<o></o>
<o> </o>
example below . <o></o>
<o> </o>
Any help is greatly appreciated . <o></o>
<o> </o>
<o> </o>

A<o></o>​	B<o></o>​	C<o></o>​	D<o></o>​
John Smith <o></o>	<o></o>	<o></o>	x<o></o>
John Smith <o></o>	<o></o>	<o></o>	x<o></o>
John Smith <o></o>	<o></o>	<o></o>	y<o></o>
Jane Smith <o></o>	<o></o>	<o></o>	x<o></o>
Jane Smith <o></o>	<o></o>	<o></o>	x<o></o>
Jane Smith <o></o>	<o></o>	<o></o>	x<o></o>
John Smith <o></o>	<o></o>	<o></o>	Y<o></o>

<tbody> </tbody>

<tbody>
</tbody><colgroup><col><col span="3"></colgroup>

 

[JoeRooney]

Sorry should have added more detail in the scenario above I would need rows 3 & 4 highlighted.

 

[JoeRooney]

Sorry the sentence should have read

I need the macro to highlight the cells that have the same first name in column A and different values in the direct cell below in column D

so rows 3 & 4 should be highlighted.
<o></o>