i'm sorry i tried and it wouldn't work correctly

"Dav" wrote:


If you apply a conditional format to your column your can make duplicate
entires stand out, so as soon as the second value is entered they will
both change colour

If your data is in column A try the following in cell a2

=COUNTIF(A:A,a2)1 entered under formula is in conditional formating
and select a colour to highlight it

This can then be copied and pasted as formats to the other cells

If it does not work, check that excel has not enclosed the formula in
quotes, if it has delete them!

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=538446