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

	A	B	C	D	E
1	123				AAA
2	123				DDD
3	123				AAA
4	456				BBB
5	456				EEE
6	444				ABC
7	555				ABC
8	789				CCC
9	888				EEE

<tbody>
</tbody>

Thanks to give me some suggestions in advance.