First, find duplicates values in a column, using Conditional formatting Click in the column you want to inspect Home/Conditional...