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

What is a VBA Module?

VBA code is stored and typed in the VBA Editor in what are called modules As stated on the VBA Editor page, a collection of modules is what is called a VBA project Every major Microsoft Office product...

ITech Analytic Solutions

0 0

INITIAL STEP FOR EXCEL

IT BECOME ITSELF LOOK LIKE A TABLE, THERE HAVE MANY CELL IN ROWWISE OR COLUMNWISE. FIRST YOU THOUGHT THAT WHAT TYPE OF DATA IS AND HOW YOU DESIGN.

Deepak Kumar Jha

0 1

Excel-Select All Data/Columns/Rows with One Click

You might know how to select all by using the Ctrl + A shortcut, but few know that with only one click of the corner button, all data/Columns/Rows will be selected in seconds.

Antony

0 0

Concatenate Function

Concatenate , one of the text functions, to join two or more text strings into one string. The Excel Concatenate function joins together a series of supplied text strings or other values, into one combined...

Saburudeen MA

0 0

Create a Grading in Excel using Formulas (All versions)

Topic: Applying Grading /Ranking in Excel (All versions Let’s Say you need to rate the Sales with some grade text like POOR, AVERAGE, GOOD and EXCELLENT Based on a range of values as mentioned...

Bhavna Philipose

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.