Choose your desired color format for emphasizing duplicates and confirm with OK. There are several different methods to handle the duplicates, but using Excel's built-in tool is the easiest.