conditional formatting, with a formula of

=COUNTIF($A$1:$A$100,A1)1

--

HTH

RP

"Skills" wrote in message
...

Hi

I have a column named item number, the user enters a number into these
cells, I would like a cell to be highlighted red if the same number is
used again as well as the orignal cell. What feature would I use to do
this?

Thanks for any help.


--
Skills
------------------------------------------------------------------------
Skills's Profile:
http://www.excelforum.com/member.php...o&userid=14946
View this thread: http://www.excelforum.com/showthread...hreadid=265935