Select the range of cells you want to check
Go to the Home tab
Click Conditional Formatting
Choose Highlight Cells Rules
Click Duplicate Values
Select the formatting style you want
Click OK
Review the highlighted duplicate entries
Use Remove Duplicates from the Data tab to delete duplicate rows if needed
Use the COUNTIF formula to identify duplicates in a helper column
Use Filter to show only duplicate values if needed