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

EXCEL DASHBOARDS BEGINNERS TO PROFESSIONALS

Rajkumar S.

0 0

Computer Basic.

If you know the design of table. Then go to second steps: 1) If you type a long data in a single cell or some other data in next cell, problem arise that the first cell data is not showing clear. Then...

Deepak Kumar Jha

0 0

Excel Keyboard Shortcuts Daily Usefull Keys

Excel KeyBoard Shortcuts Daily Usefull keys: CLTR A-Z Shift SELECT.ETC ALT All Tool Keys CLTR A Select All Shift+F11 Add New Sheet CLTR C Copy ALT...

Ninety-nine Excel Academy

0 0

Variant Datatype: Excel/Access/Office VBA

The Variant data type is the data type for all variables that are not explicitly declared as some other type. The Variant data type has notype-declaration character. A Variant is a special data type that...

Punit Kumar

1 0

Learning Pivot Table Part-1

You all must have watched movie based on War. One thing you all might have noticed, in most of the movies, armies fought with their enemies hiding inside the bunkers, an army fighting war in open obviously...

Kaustubh Chavan

1 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.