Dear all,
Is there any simple way to find double entries,other than assigning any
macros to the sheet.such as condiitonal formating.i need to need to enter more than 100 nos,if a number is repeated it should be highlighted.

Thanks In Advance,

Regards,
Akbar