Select the range of cells you want to check
Go to the Home tab
Click Conditional Formatting
Choose Highlight Cells Rules
Select Duplicate Values
Pick a formatting style
Click OK
Review the highlighted duplicate entries
Use Remove Duplicates from the Data tab to delete duplicates if needed
Select the columns to compare
Check My data has headers if applicable
Click OK to remove duplicate rows