highlighting duplicates

[ryan_kos]

In my database, I import a table from excel, then put it into a report. The report sorts the data according to sub headings. Then, if one item in a sub heading is the same as the next one, both of the items are highlighted. eg
Serial # 123
Unit # 14
Unit # 14
Both of the 14's should be highlighted. Is there a way to code this in VBA? I think that all I need is how to compare the first item to the second item

 

[David R]

How many different ways are you going to ask this question, Ryan? You now have it going in three places....follow up on one if something isn't working, instead of starting over from scratch.

 

[ryan_kos]

I'm Sorry, Richard, I didn't mean to hurt anyones feelings.