VBA for coloring duplicates base on other column

[ltsukamoto]

Hello.

I am trying to determine whether or not column A is conditional formatted using <acronym title="visual basic for applications">VBA</acronym>, and
if there is, cell on column E on same row would be selected and check if any duplicates between these selected cells,
if any, highlight.

eg, checked conditional formatting on A and base on A1:A5, check E1:E5,
find E1 and E3 is duplicated, give color

[TABLE="width: 320"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: center"]123
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]AAA
[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: center"]123[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]DDD[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: center"]123[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]AAA
[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: center"]456[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]BBB[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: center"]456[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]EEE[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: center"]444[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]ABC[/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: center"]555[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]ABC[/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD="align: center"]789[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]CCC[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD="align: center"]888[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]EEE[/TD]
[/TR]
</tbody>[/TABLE]

Thanks to give me some suggestions in advance.