Finding duplicate values in column

Steps : 

1. Below is the sample data and select all the values / data

    

2. Select Home ---> Conditional Formatting

        

        

3. Click on Highlight cell Rules    --->    Duplicate values

    (Below prompt will pop up)

    

4. Select the color of duplicate values (values with) then click on Ok

5. Duplicate values will show like below