Excel Tip: Conditional Formatting To Highlight First Value Among Duplicates.

07/06/2017 0 0

In Column “C”, I have product list and some of them are duplicates. My requirement is to format with background color of green for 1st found value among the duplicates. To solve this, I used formula in Conditional formatting. Check the below formula & screenshot.

Formula in Conditional Formatting is: =COUNTIFS($C$2:C2,C2)=1

Note: In the above formula if you write 2 instead of 1 then it will highlight 2nd duplicate value.

0 Like 0 Dislike

Follow 0

Other Lessons for You

Working with Different Versions of VBA

Office 2010 introduces a new version of Microsoft Visual Basic for Applications (VBA) known as VBA 7.0 that is updated to work with 64-bit client installations. VBA 7.0 improves the performance of your...

Punit Kumar

1 0

VBA Static Array Vs Dynamic Array

There are two types of array in VBA, Static array and Dynamic array. Static array: Array is dimenstioned during design time. Array size can not be changed. By using erase function, only array element...

Umasankar Natarajan

0 0

SQL (Structured Query Language)

SQL (Structured Query Language) is a standardized programming language used for managing relational databases and performing various operations on the data in them. Initially created in the 1970s, SQL...

ITech Analytic Solutions

0 0

Advance Excel

Technology: Excel Level: Intermediate Audience(s): Students and Professionals Language(s): English and Hindi Training method: Classroom...

Ajay Pandit

0 0

Excel Shortcuts

ShortCut Key Description F2 Edit the selected cell. F3 After a name has been created, F3 will paste names. F4 Repeat last action. For example, if you changed the color of text...

Afreen

0 0

Find Advanced VBScript Training near you

Advanced VBScript Training in Bangalore

Looking for Advanced VBScript Training?

Learn from Best Tutors on UrbanPro.

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you

Looking for Advanced VBScript Classes?

The best tutors for Advanced VBScript Classes are on UrbanPro

Select the best Tutor
Book & Attend a Free Demo
Pay and start Learning

Learn Advanced VBScript with the Best Tutors

The best Tutors for Advanced VBScript Classes are on UrbanPro

I am a Student I am a Tutor
Name*	Please enter your full name. Please enter institute name.
Email*	Please enter your email address.
Phone*	Please enter a valid phone number.
Location*	Please enter a pincode or area name.
City*	Please enter city name.
Category*	Please enter category.
Gender*	Male Female Please select your gender.
Email ID/ Mobile No.*	Please enter either mobile no. or email.
Enter Password*	Please enter OTP Please enter Password Sorry, this phone number is not verified, Please login with your email Id.