Use Excel Conditional Formatting to Enhance Data Analysis
4.0 (1 rating)
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.
632 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Use Excel Conditional Formatting to Enhance Data Analysis to your Wishlist.

Add to Wishlist

Use Excel Conditional Formatting to Enhance Data Analysis

Learn to use Conditional Formatting to Develop Your Excel Skills by Applying Colour Scales, Data Bars, Icons and More!
4.0 (1 rating)
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.
632 students enrolled
Created by John Smith
Last updated 8/2017
Current price: $10 Original price: $200 Discount: 95% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 1.5 hours on-demand video
  • 1 hour on-demand audio
  • 5 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Understand Wide Applications of Conditional Formatting
  • Apply and Modify Conditional Formatting
  • Apply Multiple Conditional Formatting Rules to the Same Group of Cells
  • Create Interactive Tables Using Conditional Formatting
  • Create Custom Conditional Formatting Rules
  • Edit Any Conditional Formatting Rules That Have Been Created In The Past
  • Use Conditional Formatting to Become More Productive Working with Excel
View Curriculum
  • Have Microsoft Excel 2007 or Later (It Works for Previous Versions But The Menu Is Different)
  • Access to computer/Internet
  • Fundamental Knowledge of Excel

Join my community of over 6,700 students learning my courses!

What is conditional formatting and why is it useful for you?

Conditional formatting allows the user to format a group of cells based on one or multiple criteria. This means that you do not have to format the cells manually and you can let Excel do all the work for you! Also, if there is change in the data Excel will automatically change the formatting, if the cell will now meet a different criteria.

Most frequently I use conditional formatting to allow me visualize the data, meaning that I can start analyzing the data before even looking at the values themselves. This means that you can increase your productivity working with Excel to a high degree using conditional formatting.

You can preview the introduction lectures in order to see some of the applications of conditional formatting in order to get a better understanding how it can be used.

About this course:

In this course I show everything step-by-step, meaning that I will be showing each single button that I press. By doing this I want to make sure that you memorize all the steps and can apply conditional formatting in your own Excel spreadsheets.

This course is designed for a beginner/intermediate level. You need to have Excel fundamentals, meaning that you will have to know how to open an Excel file, save it and other similar fundamentals. However, you do not need to have an advanced knowledge of Excel. The most advanced part of this course is when I will be teaching you to use formulas to make a condition. However, I will explain each formula in depth, meaning that you do not have to worry that you will not understand it.

However, if you are an advanced Excel user, you might still want to go through the course in order to refresh your knowledge and possibly learn a couple of new tips.

By the end of this course you will be able to:

  • Become more productive with Excel and save time
  • Enhance the data analysis capabilities with conditional formatting
  • Learn how to use conditional formatting
  • Perform multiple conditional formatting rules to the same group of cells
  • Use conditional formatting to highlight group of cells
  • Use conditional formatting top and bottom rules
  • Use conditional formatting icons to highlight cells
  • Use conditional formatting based on text rather than simply numbers
  • Learn how to use formulas in conditional formatting
  • Create various custom rules using formulas
  • Edit existing conditional formatting rules
  • Impress your manager, colleagues and clients

Other benefits from taking this course:

  • You will get lifetime access to this course
  • This course is frequently reviewed and you will get access to the new lectures for free
  • Unconditional Udemy 30 day money-back guarantee - that's my personal promise of your success!
  • My help is available to you, if you get stuck or have a question
  • I will provide you discounted coupon codes for my other Excel courses

Click the “Take this course" button at top right corner. Without the knowledge of conditional formatting you are missing awesome opportunities.

Who is the target audience?
  • Anyone Wanting to Improve Their Excel Knowledge
  • People Having Fundamental Knowledge of Excel
  • If You Are Intermediate Or an Expert, You Can Still Join the Course to Refresh Your Excel Knowledge and Possibly Learn a Few Additional Tips
Students Who Viewed This Course Also Viewed
Curriculum For This Course
74 Lectures
Introduction and the Uses of Conditional Formatting
5 Lectures 08:15

Short demonstration of conditional formatting.

Preview 03:49

Two more examples how I have used conditional formatting

Preview 02:53

Short video explaining what you should know before you take this course about Microsoft Excel

Preview 01:01

Small reminder how to improve the user experience with Udemy.

Preview 00:22

Downloadable Material for This Section Is Located in This Lecture
How to Remove Conditional Formatting
1 Lecture 01:59

Explanation of three different ways you can delete existing conditional formatting.

Preview 01:59
Highlight Cell Rules
7 Lectures 13:36

In this lecture I am talking about how to highlight cells based on greater than a value.

Greater Than

Learn how to highlight cells with values less than a certain value.

Less Than

Learn how to use between function. in conditional formatting.


In this lecture you will learn about the equal to function in conditional formatting.

Equal To

In this lecture you will learn about text that contains function in conditional formatting.

Text That Contains

You will learn about highlight cell rule called "A Date Occurring"

A Date Occurring

In this lecture you will learn about highlighting cells with either duplicate values or unique values.

Duplicate Values/Unique Values
Top and Bottom Rules
3 Lectures 04:05

In this lecture you will learn about top and bottom rules, where you can highlight x amount of top or bottom values. The X depends on your choice.

Top and Bottom X Amount of Items Conditional Formatting

Similar way to the last lecture, in this you will learn also to highlight X amount of bottom or top items. However, in this lecture we will be looking at X amount of %.

Top and Bottom X% of Items Conditional Formatting

In this lecture we will be looking, how you can easily highlight cells that have values below or above the average value for a given range.

Above and Below Average Conditional Formatting
Data Bars
1 Lecture 03:41

In this lecture you will be taught about both types of data bars, which are gradient and solid fills.

Gradient and Solid Data Bar Fills
Icon Sets
4 Lectures 05:09

Short introduction about icon sets and how the amount of icon affect the results of the conditional formatting.

Preview 01:26

Explanation of directional icon sets in conditional formatting.

Directional Icon Sets

In this lecture you will lean about shapes and indicators under icon sets in conditional formatting.

Shapes and Indicator Icon Sets

In this lecture you will lean about ratings under icon sets in conditional formatting.

Ratings Icon Sets
Slightly More Advanced Conditional Formatting
4 Lectures 13:05

In this lecture you will learn about conditional formatting based on a specific cell and this method is hihgly recommended to use for everyone as it becomes simpler to edit the Excel file and change the Conditional Formatting criteria.

Conditional Formatting Based on a Specific Cell (Highly Recommended)

How you can use conditional formatting together with filters in order to find the data you want to analyze.

Using Conditional Formatting In Filters

In this lecture I am explaining the order of conditional formatting, as there might be cases, where multiple rules will be applied to same cells. Also, I cover, how you can change the order in this lecture.

Order of Conditional and How to Change It

In this lecture I discuss how you can copy and paste conditional formatting into another sheet or even to another workbook. You can use this to apply the same conditional formatting rules much faster!

Copy and Paste Conditional Formatting into Another Worksheet or Workbook
Using Formulas in Conditional Formatting
13 Lectures 30:08

This lecture will teach you about the menu of the custom formulas for conditional formatting.

Preview 04:24

In this lecture you will learn how to lock rows, columns or both. This is crucial knowledge, when you start building your own formulas in conditional formatting.

Before Creating Custom Formulas You Need to Know How to Lock Rows and Columns

This lecture will teach you how you can highlight cells with time information using custom formulas.

Highlight Cells Containing Time Information Using Formulas

In this lecture we will cover how you can create custom icon set ranges rather than using the presett.

Creating Custom Icon Set Ranges

Instead of only highlighting the cells in the columns, you will learn how to highlight the whole row based on one column.

Highlighting the Whole Row Based on a Column

In this lecture you will learn how to make a dropbox and use it to select what you want to highlight using conditional formatting.

Dynamic Way of Selecting Whole Row Based on a Cell

Comparing Values In Two Columns Using Formulas

In this lecture you will learn how to compare two lists either for matches or mismatches, depending on your choice.

Comparing Two Different Lists For Matches or Mismatches

Learn how to change the colours of the alternating rows.

Changing Colours of Alternating Rows Using Formulas in Conditional Formatting

Rather than using presets, learn how to write formula for finding duplicates.

Finding Duplicates Using Formulas in Conditional Formatting

Finding Duplicates Using Criteria From Two Columns

There are cases, where you need to compare subtotals. Conditional formatting is perfect for that.

Using Conditional Formatting to Find Discrepancies

Downloadable Material for This Section Is Located in This Lecture
1 Lecture 00:27

In this lecture I simply remind you that I will keep this course up to date and I will continue to add new lectures.

Preview 00:27
BONUS: Discounts of My Other Courses
1 Lecture 00:12

Other Excel courses I have created.

My Other Microsoft Excel Courses and Their Discounts
1 More Section
About the Instructor
John Smith
3.8 Average rating
69 Reviews
6,773 Students
8 Courses
Online Entrepreneur

Over 6,700 unique students from 136 different countries are studying my courses.

I have been an online entrepreneur since 2010 using various methods of earning money online. I have multiple YouTube channels, tried working with affiliate marketing, consultant on Internet, Forex, selling e-books and an online teacher on Udemy. I love to share my own experiences both from my entrepreneur life and also when I was working in one of the largest corporations in the world (see my CV below).


YouTube: Over 10 million viewers on my main channel, increasing by 250,000 viewers per month. I have several other channels, which are training related.


I started teaching on Udemy in October 2014 and I have gained over 6,700 unique students. I am enjoying teaching and very passionate about helping people solve their problems, grow their business and improve their lives. I can proudly say that I have helped people across the 6 different continents.

My CV:

I finished my BSc Business and Management in one of the top UK universities with a first class degree. After getting the degree, I worked in one of the major corporation that is in Fortune 500 - General Motors. Hence, I am familiar to the corporate culture and the daily life of working in major corporations.

While working for the corporation I have come across many different people that I had to work with. I have also had the opportunity to attend many different business trips in various countries with different cultures, which has allowed me to understand how differently business operations are carried out in different countries.

Right now I work online as an entrepreneur, which has been mentioned before.