Excel

Hi All,

I have a total of 9000 data in a table. In this many are duplicate entries. I tried to filter the wrong entries using conditional formatting (Conditional formatting > highlight cell rules> duplicate values). After applying this rule i tried to remove duplicate entries using filter button. However the Filter by color option is grayed out. Can anyone help me to sort this issue? Is there any other way to find dual entries?
Thanks in advance.