Excel Find and Highlight Duplicate Values in Columns (Rows)

Introduction: 

Here I will explain how to find and highlight duplicate rows in excel or find duplicate values in excel columns and highlight it or find and highlight duplicate values in excel with colors. By using excel highlight cells rules property in conditional formatting section we can find and highlight duplicate values in excel columns.

Description:
  
In previous articles I explained compare two columns values and show duplicate values in excel, shutdown system automatically in windows 7, keyboard event key codes and character codes, create desktop shortcut key to lock computer, configure dns server in windows 7. Now I will explain how to compare excel columns to find duplicate values and highlight it.

I have one excel file with two username columns like as shown below

Now I want to highlight duplicate values in both columns for that follow below steps

1. Select both columns like as shown below

2. Now in excel top header / ribbon click on Conditional Formatting à in that hover on Highlight Cells Rules à Click on Duplicate Values like as shown below

3. Whenever we select Duplicate Values option it will highlight duplicate values in columns like as shown below

I hope it helps you to get duplicate values from two columns……

If you enjoyed this post, please support the blog below. It's FREE! Get the latest Asp.net, C#.net, VB.NET, jQuery, Plugins & Code Snippets for FREE by subscribing to our Facebook, Twitter, RSS feed, or by email.

Subscribe by RSS Subscribe by Email