Aspdotnet-Suresh

aspdotnet-suresh offers C#.net articles and tutorials,csharp dot net,asp.net articles and tutorials,VB.NET Articles,Gridview articles,code examples of asp.net 2.0 /3.5,AJAX,SQL Server Articles,examples of .net technologies

Excel Find and Highlight Duplicate Values in Columns (Rows)

Jun 18, 2015
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


Excel Find and Highlight Duplicate Values in Columns (Rows)

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 RSS subscribe by email Subscribe by Email

0 comments :

Give your Valuable Comments

Other Related Posts

© 2015 Aspdotnet-Suresh.com. All Rights Reserved.
The content is copyrighted to Suresh Dasari and may not be reproduced on other websites without permission from the owner.