How do I flag up duplicate data entry in an excel spreadsheet?
 

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

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

How do I flag up duplicate data entry in an excel spreadsheet?
 

ah ok will give it a shot. Thanks

"T. Valko" wrote:

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