Is there a formula that can spot duplicate reference des's

M

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.
 
S

Sebation.G

another choice
u also can use Data formatting to change the color
i.e table_array:range("a1:a10")
choose a1>data formatting>cell 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.
 
Top