Highlight Duplicate on entry

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

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

http://www.cpearson.com/excel/dupli...htingDuplicates
--
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" <jk@discussions.microsoft.com> wrote in message
news:19BF5ADC-9531-43CD-8261-93F2A7980E9D@microsoft.com...
> 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

"jk" wrote:
> 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?

Perhaps try also Data Validation ..

Assuming it's for inputs into col A ..

Select col A
Click Data > Validation
Allow: Custom
Formula: =COUNTIF(A:A,A1)<2
Click OK

Test it out ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---