duplicates to be coloured

[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">
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 _LD,_EN,_TM 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..............

 

[anandvarma]

Try this

=or(right(a1,3)="_ld",right(a1,3)="_en",right(a1,3)="_tm")

 

[rupashree]

Try this

=or(right(a1,3)="_ld",right(a1,3)="_en",right(a1,3)="_tm")

no its not working

 

[anandvarma]

you have to put it in the conditional formetting