How to Find Duplicate or Unique Value in Excel with Conditional Formatting

Our Reader Score
[Total: 0 Average: 0]
Reading Time: 2 minutes
Hello ITKians 
Whenever you work on excel, you want to sort duplicate value but not easily get because of lack of excel knowledge
  In today’s Excel tutorial I am teaching you to find out Duplicate or Unique value from the excel sheet
For Tutorial I create a sample sheet in which I write some duplicate number.


    1.    First select the whole column in which you want to find duplicate value.
   2.    Now Click on Conditional Formatting tab and do as shown in below image.
   3.    Choose Either Duplicate or Unique value from drop down list in which you want to apply formatting and in “Value with” field select the output type. either you want duplicate value highlighted with blue black or any color and format you want. (Use coustom for your choice formatting)
   4.    I choose “Duplicate” value which is highlighted with “Light red fill with dark red text” .  Now you see all duplicate value Highlighted with Light red fill with Dark red text
   Like Comment and Share the post and Dont forget to 
   Subscribe IT KEEDA