true

Learn Microsoft Excel Training from the Best Tutors

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

Search in

Hide Duplicate Values & Apply Borders Using Conditional Formatting

02/01/2020 1 0

Please refer following screenshots:
1st Screenshot: Original Dataset
2nd Screenshot: After Conditioinal Formatting is applied

In 2nd screenshot, using Conditional Formatting:
1) Repeat months are hidden
2) Borders are applied

Dataset range: A1:C17
In Conditional Formatting:
1) Formula applied to hide repeat months: =(A2=A1)
In Conditional Formatting, under Formatting, simply choose Font Colour White. White colour will hide repeat months.
2) Formula applied to apply borders: =($A3<>$A2)
In Conditional Formatting, under Formatting, choose Border Style and Colour.

1 Like 0 Dislike

Follow 1

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

0 0

VBA Function - RIGHT

RIGHT function in VBA returns the Specified number of characters from the end of a text string Syntax: Right(String,Length) Sub RIGHT_1() Dim mystring As String mystring = "Narendra Modi" MsgBox Right(mystring,...

Karthik

0 0

What is a SQL join?

A SQL join is a Structured Query Language (SQL) instruction to combine data from two sets of data (e.g. two tables). Before we dive into the details of a SQL join, let’s briefly discuss what SQL...

ITech

0 0

Most important things to remember while doing VLOOKUP! (Donts..)

Make sure there are no unwanted or additional spaces in between the words or afterwards Example: Robert Smith_ Note: To show the additional spaces I have underlined the entire words. Don’t...

Shylaja

0 0

How Lookup function to replace Nested If statement

Nested If statements are complicated to type down and include many parameters. The best method to replace them is to use the lookup function. Using the lookup function shortens the formula at a considerable...

Kaustubh

0 0

Find Microsoft Excel Training classes near you

Looking for Microsoft Excel Training classes?

Learn from Best Tutors on UrbanPro.

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you

Microsoft Excel Training Questions

What is VBA and what is its importance?

5 Answers

How to use the h look up in excel worksheet ???

24 Answers

Dear sir,how to convert number to text in excel by formula?

8 Answers

Is there any free software to convert a word file to PDF?

7 Answers

Make A Excel Software Challenge: To Track Time Records To Enhance Daily Output Of Staff

7 Answers

Looking for Microsoft Excel Training Classes?

The best tutors for Microsoft Excel Training Classes are on UrbanPro

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

Learn Microsoft Excel Training with the Best Tutors

The best Tutors for Microsoft Excel Training 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.