I have a full spread sheet of 10,000 description of entries that are
numbered. There are duplicates in this spread sheet and I need to leave them
because of the numbering. I want to write "DUPLICATION" over the parts of
the spread sheet that are duplicates in a bigger and maybe colored font to
save my supervisor time when she reviews the spread sheet. It would look
like someone took a stamp and stamped the spread sheet. How do I do this...I
have forgotten how.

I think I'd use a helper column of cells. Then I could even apply
Data|Filter|autofilter and show just what I wanted.

Chip Pearson has lots of ways to work with duplicates at:
http://www.cpearson.com/excel/duplicat.htm

He even includes a way to use Format|conditional Formatting to hide duplicates.
But you could use a different font/fill color if you wanted.

Michel wrote:

I have a full spread sheet of 10,000 description of entries that are
numbered. There are duplicates in this spread sheet and I need to leave them
because of the numbering. I want to write "DUPLICATION" over the parts of
the spread sheet that are duplicates in a bigger and maybe colored font to
save my supervisor time when she reviews the spread sheet. It would look
like someone took a stamp and stamped the spread sheet. How do I do this...I
have forgotten how.

--

Dave Peterson