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>
[TABLE="class: MsoNormalTable, width: 203"]
<tbody>[TR]
[TD="width: 79, bgcolor: transparent"]

A<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

B<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

C<o></o>​

[/TD]
[TD="width: 64, bgcolor: transparent"]

D<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 79, bgcolor: transparent"] John Smith <o></o>
[/TD]
[TD="width: 64, bgcolor: transparent"] <o></o>
[/TD]
[TD="width: 64, bgcolor: transparent"] <o></o>
[/TD]
[TD="width: 64, bgcolor: transparent"] x<o></o>
[/TD]
[/TR]
[TR]
[TD="width: 79"] John Smith <o></o>
[/TD]
[TD="width: 64"] <o></o>
[/TD]
[TD="width: 64"] <o></o>
[/TD]
[TD="width: 64"] x<o></o>
[/TD]
[/TR]
[TR]
[TD="width: 79"] John Smith <o></o>
[/TD]
[TD="width: 64"] <o></o>
[/TD]
[TD="width: 64"] <o></o>
[/TD]
[TD="width: 64"] y<o></o>
[/TD]
[/TR]
[TR]
[TD="width: 79, bgcolor: transparent"] Jane Smith <o></o>
[/TD]
[TD="width: 64, bgcolor: transparent"] <o></o>
[/TD]
[TD="width: 64, bgcolor: transparent"] <o></o>
[/TD]
[TD="width: 64, bgcolor: transparent"] x<o></o>
[/TD]
[/TR]
[TR]
[TD="width: 79, bgcolor: transparent"] Jane Smith <o></o>
[/TD]
[TD="width: 64, bgcolor: transparent"] <o></o>
[/TD]
[TD="width: 64, bgcolor: transparent"] <o></o>
[/TD]
[TD="width: 64, bgcolor: transparent"] x<o></o>
[/TD]
[/TR]
[TR]
[TD="width: 79, bgcolor: transparent"] Jane Smith <o></o>
[/TD]
[TD="width: 64, bgcolor: transparent"] <o></o>
[/TD]
[TD="width: 64, bgcolor: transparent"] <o></o>
[/TD]
[TD="width: 64, bgcolor: transparent"] x<o></o>
[/TD]
[/TR]
[TR]
[TD="width: 79, bgcolor: transparent"] John Smith <o></o>
[/TD]
[TD="width: 64, bgcolor: transparent"] <o></o>
[/TD]
[TD="width: 64, bgcolor: transparent"] <o></o>
[/TD]
[TD="width: 64, bgcolor: transparent"] Y<o></o>
[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 270"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody><colgroup><col><col span="3"></colgroup>[/TABLE]

 

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