You could use conditional formatting, with a formula of say
=COUNTIF(B:B,B1)1. This will then highlight them both as you enter it.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"items entered twice" <items entered wrote
in message ...
I enter orders we receive for our business. I list them down in a column,
is
there anyway I can tell if I have entered one more than once without
having
to go back and check every time?