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"] [/TD]
[TD="width: 64, bgcolor: transparent"] [/TD]
[TD="width: 64, bgcolor: transparent"] [/TD]
[TD="width: 64, bgcolor: transparent"] [/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]


<o


Wondering if someone could assist me with some code to identify cell differences in a spreadsheet.<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


example below . <o


<o


Any help is greatly appreciated . <o


<o


<o


[TABLE="class: MsoNormalTable, width: 203"]
<tbody>[TR]
[TD="width: 79, bgcolor: transparent"]
A<o
></o
>


[TD="width: 64, bgcolor: transparent"]
B<o
></o
>


[TD="width: 64, bgcolor: transparent"]
C<o
></o
>


[TD="width: 64, bgcolor: transparent"]
D<o
></o
>


[/TR]
[TR]
[TD="width: 79, bgcolor: transparent"] John Smith <o


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


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


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


[/TD]
[/TR]
[TR]
[TD="width: 79"] John Smith <o


[/TD]
[TD="width: 64"] <o


[/TD]
[TD="width: 64"] <o


[/TD]
[TD="width: 64"] x<o


[/TD]
[/TR]
[TR]
[TD="width: 79"] John Smith <o


[/TD]
[TD="width: 64"] <o


[/TD]
[TD="width: 64"] <o


[/TD]
[TD="width: 64"] y<o


[/TD]
[/TR]
[TR]
[TD="width: 79, bgcolor: transparent"] Jane Smith <o


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


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


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


[/TD]
[/TR]
[TR]
[TD="width: 79, bgcolor: transparent"] Jane Smith <o


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


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


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


[/TD]
[/TR]
[TR]
[TD="width: 79, bgcolor: transparent"] Jane Smith <o


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


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


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


[/TD]
[/TR]
[TR]
[TD="width: 79, bgcolor: transparent"] John Smith <o


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


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


[/TD]
[TD="width: 64, bgcolor: transparent"] Y<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]