Excell Macro

I want to compare value of a cell of an excell sheet to all other value of the same column and if any entry is duplicated in the column a message box should be displayed and the cell that contains the duplicate entry should be highlighted.i am unable to do it plz help me.
Thnx,
Mumtaz
(mumtazh@ndtv.com)