View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
john talbot john talbot is offline
external usenet poster
 
Posts: 1
Default How do I auto highlight a cell with the same data as another cell

I have a spreadsheet containing lists of serial numbers. If I enter a serial
number which already exists in the spreadsheet, I would like the new cell to
be highlighted to indicate that the entry already exists - is this possible?