Hi to all

This topic is for the bounty managers. You can now easily find the duplicates and highlights it

1. Select the what you want to filter the duplicates.
2. Click Format
3.Click Conditional formatting
4. Click Add new rule
5. Set Format cells if to: Custom formula is:
6. Set value to: =countif(A:A,A1)>1
7. Set the formatting style.
8. Ensure the range applies to your column (e.g., A1:A100).
Done. Anything you write in the A1:A100 cells will be checked, and if there is a duplicate (occurs more than once) then it'll be coloured.

For multiple columns, use countifs.