View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default How do I flag up duplicate data entry in an excel spreadsheet?

You can use conditional formatting to highlight the customer name if their
last order/contact (?) date is within 2 months of todays date.

But, you need to give use some detailed info of where this info is.

--
Biff
Microsoft Excel MVP


"laulea1" wrote in message
...


I have a spreadsheet made up of customer addresses and would like to flag
up
if we have had dealings with a customer in a 2 month period without having
to
search and find every time I have to enter data.

Any idea if there is a simple way to do this?

Thanks