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

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


नमस्ते _/\_ to all . This is JOY DUTTA working in Spark Minda group as a IT Engg from last 4 years , I completed my Diploma from Goverment Polytechnic Dehradun in Computer Science And Engg in 2011.Well, above i written my Qualification and My JOB Role. now i am tell you about Who am i as a person. I am a fun loving guy who love Acting, Dancing, Hangout with friends, I believe in Smart work Rather Than Hard work. I love computers because I love Computers :)In short I am interesting guy if you want reveals more about me You should to meet me. if that not possibleMail me :- or Join me on Facebook:-

Leave a Reply

%d bloggers like this: