Is there any way of searching for duplicate cells?

[Lisa]

Is there any way that i can do a easy search for duplicate cells, i am
working on a very large spreadsheet.

 

[Norman Jones]

Hi Lisa,

See Chip Pearsons Duplicates page at:

http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates