true

Learn Advanced VBScript from the Best Tutors

Affordable fees
1-1 or Group class
Flexible Timings
Verified Tutors

Search in

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

07/06/2017 0 0 View Comments

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

Conditional formatting with formulas

Conditional formatting quickly formats information in a spreadsheet. But sometimes the biult in rules are not enough. Adding your own formula to a conditional formatting rule gives it a power to help you do custom things.

Sharad Singh

0 0

HERE TODAY WE WILL USE THE SUMIF FUNCTION

A B C 1 PRODUCT NAME TOTAL AMOUNT 2 WASHING MACHINE 3616 3 MI PHONE 4978 4 SAMSUNG MOBILE 3825 5 NOKIA PHONE 3902 6 T.V 3759 6 L.G REFRIGERATOR 3693 7 BOTTLE 4191 ...

Saurabh Sharma

0 0

Compiler vs Interpreter

Compiler Interpreter Convert all the code into binary format and execute. Convert one statement at a time and execute, then Convert next statement and execute. After conversion, source...

Umasankar Natarajan

0 0

Importance of dash board in Business/org

A business intelligence (BI) dashboard is a data visualization tool that consolidates and displays the current status of metrics and key performance indicators (KPIs) for an organization, department or...

Shashank Maheshwari

2 0

Learn in Excel To Create a LIST in One Minute

Sanjay Singh

7 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

Migrate

Class

Subject

Chapter

Migrate to

Concept Solution

Migration Successful

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.