Under the tab
Kutools, find the group
Editing, click
Select >
Select Duplicate & Unique Cells.
In the pop-up dialogue box,:
1. Click the range-select button (targeted with a red arrow) to select the row you mentioned.
2. Under the
Based on section, select
Single cell.
3. Under the
Rule and
Processing of results sections, select the options you need.
4. Click
OK. The duplicates will be then selected and displayed in the way you set.