Notification on entering the same data twice

[S.G.Pillai]

I need to get a notification when i enter a data twice in the work sheet.

 

[Ron de Bruin]

Hi S.G.Pillai

Maybe you like this
http://www.cpearson.com/excel/NoDupEntry.htm