Excel 2007 Highlight only duplicate cells that are next to each other?

SETTE

New member
In Excel 2007 is there a way to highlight only duplicate cells that are next to one another if so how? my data is listed vertically.
 
Back
Top