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

[Guest]

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

 

[T. Valko]

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.

 

[Guest]

ah ok will give it a shot. Thanks

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.