another choice
u also can use Data formatting to change the color
i.e table_array:range("a1:a10")
choose a1data formattingcell value "=countif($a$1:$a1,a1)<1" set the
color then drop down(just copy the format)

PS.while u use the excel 2007 it will be more easy cas it privide this
rules.



"Michaela" ...
I need a formula that will spot duplicate reference diesignator's such as
if
you have mo9310 more than once, the cell will say ref! or change color.