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

How to generate datasets?

Anyone can easily generate dataset numeric datasets using RANDBETWEEN function. This function generates random numbers between specified values. After using this function you can copy the range to which...

Akhilesh Dadhich

0 0

Hidden Excel Feature - Camera

Mahesh Kathiravan

1 0

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

Hidden Gems Of MS Excel - Consolidate

Situation: You are part of the Finance Team, and work at Headquarters of an Organization.Periodically, You receive expense data from Teams in different Regions.After You receive expense data, You SUM all...

Ankur Sharma

1 0

Excel Macros Training

The Next Level Technologies Excel Learning...Read & Share....Happy Learnings Record Macro (Automating day to day activity reports) -> Choose Record Macro in the Code group of the Developer...

Next Level Technologies

0 0

Find Advanced VBScript Training near you

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.