I have a rather large spreadsheet of Names, addresses, etc. I have noticed
that there are many duplicate entries.

any suggestions or formulas that would allow me to highlight the duplicates
preferably in color, would be much appreciated.

Please keep in mind, that I am a beginner with excel, so I need something
simple and uncomplicated.......Thanks