ExcelBanter - View Single Post - Highlighting duplicate values in a column

(Jeff) wrote in message . com...
Our department is involved in project managing office moves. The
moving department is given an excel 2002 spreadsheet and they fill out
the names of the people moving (column A) along with their extension
number (column B). I would like it to pop up a message if an
extension number is entered and is a duplicate of one already entered,
giving the person's name it's duplicated with.

Any help would be gratefully received

TIA

Ignore this, I've managed to use the validate function