You could use format|conditional formatting

Debra Dalgleish has some instructions:
http://www.contextures.com/xlCondFor...html#Duplicate

Supress Repeating values in a column wrote:

How do I format worksheet so that consecutive repeating values in a column
will appear only once in the first row and suppressed in the following rows?

--

Dave Peterson