jk, have a look here for a way to do it,

http://www.cpearson.com/excel/duplic...tingDuplicates
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"jk" wrote in message
...
Hi,

I need something that would highlight the cell entry if there is a
duplicate
entry located on the sheet.For instance, i enter account N15650 in the
account column and if this entry has previosly been made in the same
column
then i want this new entry to be highlighted as a flag for me.Does this
require a macro or vb for this action?
Thanks