colouring of duplicates

[rupashree]

hi...i have data with duplicates like

<table width="238" border="0" cellpadding="0" cellspacing="0"><col style="width: 179pt;" width="238"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt; width: 179pt;" width="238" height="17">BM1001177_SPMP907817_LD</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt;" height="17">BM1001177_SPMP907817_EN</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt;" height="17">BM1001177_SPMP907817_TM</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl23" style="height: 12.75pt;" height="17">
BM1001939_SPMP907641_LD</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl23" style="height: 12.75pt;" height="17">BM1001939_SPMP907641_EN</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl23" style="height: 12.75pt;" height="17">BM1001939_SPMP907641_TM</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
if data is duplicate like below with only two rows it should not be coloured.
BM1001556_SPMP907642_LD</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">BM1001556_SPMP907642_EN

the rows with duplicate data ending with _EN,_LD,_TM three rows,SHOULD BE COLOURED.when all the three _LD,_EN,_TM come it should be marked....rest should not be marked.
</td> </tr> </tbody></table>please help me..............