Exceljet

Quick, clean, and to the point

Select row differences

Windows shortcut 
Ctrl\
Mac shortcut 
\

This shortcut will select all cells that don't match the value in the active cell in a row or selection within a row. Note that this shortcut depends on the location of the active cell in a selection. You may want to start your selection with the active cell or move the active cell after the selection is made.

This is the best Excel training site I have ever seen. -Kedy
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Shortcuts Video Course
Excel Charts video training course