Excel Conditional Formatting Master Class

Learn how to use Conditional Formatting in Excel! Take your knowledge and skills to the next level.
4.5 (17 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
1,207 students enrolled
75% off
Take This Course
  • Lectures 37
  • Length 3.5 hours
  • Skill Level Intermediate Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


Learn and practice real-world skills and achieve your goals.

About This Course

Published 4/2014 English

Course Description

Over 1000 people have taken this course!

When you see conditional formatting in Excel for the first time, you are amazed, to put it mildly. If Excel formatting makes your spreadsheets visually pleasant, conditional formatting in Excel makes them infinitely more powerful and useful. In this easy-to-follow Excel course, you will not only learn the basics of conditional formatting in Excel, but also become comfortable with more advanced conditional formatting techniques, such as conditional formatting based on text, conditional formatting based on another cell, conditional formatting based on a date, or on a range of dates, as well as conditional formatting with formulas, range-based conditional formatting rules and more. This Excel conditional formatting course will quickly build your Excel skills. It will serve you well as an Excel conditional formatting tutorial that takes your productivity to the next level.

When you take this course, you will benefit from over 3 hours of high-quality video material, so you can quickly improve your Excel skills. After you enroll and complete this course, you will have acquired various carefully selected conditional formatting tips and tricks.

This course is designed with a conditional formatting problem-solving approach in mind. The majority of these high-quality video lessons first introduce and define a specific, real-life problem and then provide an elegant conditional formatting based solution, so you can apply the newly-acquired skills immediately.

After you have taken this course, you will:

1) Become more productive in Excel.

2) Enhance your conditional formatting skills.

3) Save time with conditional formatting at work.

4) Make your spreadsheets more dynamic with conditional formatting.

5) Impress your boss, your colleagues, and your clients.

6) Improve your data analysis capabilities with conditional formatting.

7) Become comfortable with conditional formatting formula based rules.

This Excel course is one of the Easy Excel With Igor series. The other high quality Excel tutorials include:

"Microsoft Excel Without Pain" that helps you quickly build your foundation skills in Excel;

"Data Manipulation In Excel" allowing you to save up to 90% of time when using Excel for certain data management tasks;

"Excel Pivot Tables Data Analysis Master Class" that takes you step by step to mastering pivot tables data crunching skills;

"Microsoft Excel Charts Master Class" that builds your skills in creating your skills in Excel charts and graphs.

What are the requirements?

  • Access to a computer with Excel installed.
  • Recommended to take my Excel Without Pain course

What am I going to get from this course?

  • Learn the power of conditional formatting in Excel.
  • Use Conditional Formatting to save time at work
  • Become more creative in Excel.
  • Acquire specific ideas and proven strategies to become more productive in Excel.
  • Make your spreadsheets more dynamic with conditional formatting

What is the target audience?

  • Excel users of any level.
  • Anyone looking for a better way in Excel.
  • Anyone who wants to learn to effectively use conditional formatting in Excel

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.


Section 1: First Things First

What is conditional formatting anyway?

Navigating Udemy Course Interface

A few points before you begin to enjoy the course.

Section 2: Pre-set Conditional Formatting Rules In Excel

Let's discover a problem that can be solved with Conditional Formatting based on text.


Here we learn how to use conditional formatting based on text, or text-based conditional formatting in Excel.


Let's introduce a conditional formatting based on numbers. These are less than, greater than, equal to conditional formatting rules.


Let us take a look at how you can benefit from the conditional formatting based on numbers rules. The Less than, greater than, equal to conditional formatting.


Here we take a look at an example of Excel conditional formatting based on a date, or date-based conditional formatting rules.


Let's learn how to apply the Date Occurring conditional formatting in Excel. These are the date-based conditional formatting rules.


Let's see how we can find duplicates with conditional formatting in Excel.


Let's learn the technique of finding duplicates in Excel with conditional formatting.


Here we introduce how to look for highest or lowest values with Excel conditional formatting. These are called Top-Bottom conditional formatting rules in Excel.


Let us learn now how to use the top-bottom conditional formatting rules in Excel.


These are relatively new Excel conditional formatting rules called Data Bars, Icon Sets and Color Scales. They make you more productive in Excel spreadsheets when you work with data.


Let's learn how to create conditional formatting in Excel to display Data Bars, Icon Sets, Color Scales.


In this lecture we explore how you can copy and clear conditional formatting in Excel.

Some Useful Points On The Default Conditional Formatting Rules
Section 3: Custom Conditional Formatting Rules In Excel

Here we overview the Conditional Formatting tools in Excel. It is important to be comfortable with these Excel tools in order to create impressive custom Conditional Formatting rules in Excel.


Here we explore custom Conditional Formatting rules using Icon Sets in Excel.


In this lecture we learn to display Icon Sets in Excel in a different column by using Excel Conditional Formatting.


Let's create Icon Sets in Excel based on a formula-based conditional formatting rule.


Here we play with conditional formatting icon sets in Excel based on Percents and Percentiles.


Let's keep learning custom Excel Conditional formatting. Here we play with custom Data Bars in Excel.

Section 4: Formula-Based Conditional Formatting

Let's introduce Excel conditional formatting based on a formula. A very powerful technique.


Here we learn how to create formula-based conditional formatting in Excel. Amazing!


Here we explore an example of conditional formatting based on date in Excel.


Let us learn how to use date--based conditional formatting in Excel.


One more useful example of Excel conditional formatting based on dates.

Conditional Formatting Based On VLOOKUP - Problem Definition

This your tutorial on using Conditional Formatting based on VLOOKUP finction in Excel.


Let's explore how we can use conditional formatting to alternate row color in Excel.


Question. How can I highlight row and column in Excel by using Conditional Formatting?


Let's go step by step and learn how to highlight row and column by using Excel conditional formatting.

Section 5: One For The Road

Let me show you one fun example of using Conditional Formatting based on a formula in Excel.


This is your tutorial on how to do fun things with formula-based conditional formatting in Excel.

Section 6: Real-Life Problem Solving

Here we solve a real-life conditional formatting problem presented by Dayan Montano.

Bonus Lecture: Special Offers

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Igor Ovchinnikov, Bringing you an easier way to learn!

Hi, I am Igor Ovchinnikov.

I am here to teach you. My focus is to help you improve your skills, so you can do you job well. You probably want to learn fast and get results quickly? You might even remember a time when you really enjoyed learning something? Well, when you buy my courses, that’s exactly what you get. I do my best to serve you with easy learning experience, fast results, and even some fun.

Now, a bit about me. I live in San Francisco and do corporate training. I am the go-to guy when companies need training for their employees. 

I’ve done it for many organizations such as Apple Computers, Stanford University, University of California, Google, Boston Scientific, Altera, Stryker Endoscopy, Air Liquide, BAE Systems, City of San Francisco, Anritsu, Genentech, Novartis, Bayer, Systron Donner, and many others. There are too many to list all of them here. If my training was good for them, perhaps it will be good for you.

I hold an M.B.A. from Ohio State University, and am a PMI®-certified Project Management Professional (PMP®).

As for my on-line courses here, you can see all of them below on this page. Just click on the ones you are interested and enroll.

Ready to start learning?
Take This Course