Categories: Excel

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.


Related Post
  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
Leave a Comment
Disqus Comments Loading...
Published by

Recent Posts

What Should You Consider When Buying A Refurbished Laptop?

When a laptop is sold as refurbished, it would mean a couple of things. To…

1 year ago

Recommended Smartphones for Online Casino Games

The advancement in technology has significantly changed the way of life of many people. Today,…

1 year ago

Things to Consider while Developing Food Delivery App

Online food delivery has become a common trend among the Millennials and the Gen Z.…

1 year ago

Router Tips To Have Uninterrupted Wi-Fi At Home

In the current Covid-19 pandemic scenario, work from home is a necessity, and so is…

2 years ago

How to detect a good CMS developer

The role of CMS developer includes coping with content management systems, or the software that…

2 years ago

Top 5 Websites to chat anonymously with Random People

Are you searching Top 5 Websites to chat anonymously with Random People so you are…

2 years ago