Highlight Duplicate on entry jk 11.07.2006 14:02:02 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

Re: Highlight Duplicate on entry "Paul B" <to_much_spam_to_list[ at ]nospam.com> 11.07.2006 15:10:31 jk, have a look here for a way to do it, http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates -- 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[ at ]discussions.microsoft.com> wrote in message news:19BF5ADC-9531-43CD-8261-93F2A7980E9D[ at ]microsoft.com... [Quoted Text] > 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

Re: Highlight Duplicate on entry Max 15.07.2006 09:46:01 "jk" wrote: [Quoted Text] > 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 ---