check out Chip Pearson's site for help with this

http://www.cpearson.com/excel/duplicat.htm


"Robert,MofD" wrote:

I am using microsoft excel 2000, (9.0.2720)

In a list of bookings, comprising names locations and dates, I need to
highlight any problem of duplication. So if I book the same person into two
locations on a single date or two people for the same location on a single
date I need to highlight that problem. Is there a method of doing this in
excel please?