View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.setup
jk jk is offline
external usenet poster
 
Posts: 109
Default 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