About step by step procedure:
- Select Entire Column where you want apply this feature.
- CTRL + SPACE.
- Home --> conditional formatting --> Highligth Cells rules --> Duplicate values...
- At windows prompt select "Duplicate" and "Light Red Fill With Dark Red Text".
- Here it is visual result:
Here it is a simple video.