Master Excel Conditional Formatting

Would you like to impress people by showing them a simple Excel spreadsheet that you created?

What is the quickest way to make Excel reports more useful and beautiful? How can you make them easier to read and understand?

The answer to these questions is simple:

Learn Conditional Formatting

If you use Excel, conditional formatting is a required knowledge.

You may wonder why? 

Actually, there are several reasons…

  • It is the most reliable way to make your spreadsheets stand out from the mediocre crowd.
  • It transforms a dry, boring spreadsheet into a dynamic presentation tool.
  • You can communicate vital information better and make your work more impressive.
  • It is that secret sauce that makes a tremendous difference in your work.
  • You can astonish everyone who sees your spreadsheets for the first time.
  • It almost guarantees to position yourself as a true professional.

So, what is conditional formatting, and why should you take time to learn it?

In simple terms…

It is an Excel tool that lets you format cells according to some preset logic. Without manual reformatting.

Which means you can create and apply dynamic format rules that adapt to data values.

You can give your spreadsheets amazing ability. When the data changes, the report repaints itself. Like a chameleon.

Imagine, for example, cells’ background colors, styles, borders, font, etc. changing with data. Which brings those changes to your attention at once.


Conditional formatting is a terrific way to compare values in a range of cells. Because you will see important data patterns at once—without wasting time. It would be almost impossible to do without conditional formatting.

That is why it is smart to learn and use conditional formatting.

This course teaches you how to use conditional formatting in Excel. Step by step, you learn powerful secrets and practical techniques of conditional formatting. So you can take advantage of it in your everyday work.

You will get started with the basic highlight-cells rules. And by the end, you will be creating advanced, elegant, formula-based solutions.

Here is what you will learn in this course:

Basic Conditional Formatting Rules

  • What is conditional formatting and when you should use it?
  • How to highlight vital information and make data easier to read.
  • Apply simple highlight-cells rules. Such as “greater-than,” “less-than,” “between,” “a date occurring” and “duplicate values.”
  • Apply conditional formatting to entire ranges, so you can show visual data patterns.
  • Built-in and custom range-based conditional formatting rules. Such as data bars, color scales, and icon sets.

Conditional Formatting and Formulas:

  • How to use a formula to determine which cells to format.
  • Create custom formula-based conditional formatting rules for your specific scenarios and use cases.
  • The importance of absolute and relative cell references in conditional formatting.
  • Conditional formatting rules based on multiple logical criteria.
  • How to use VLOOKUP in conditional formatting.
  • How to use the logical IF, OR, AND functions with conditional formatting.
  • Use conditional formatting to highlight rows, columns, or both.
  • How to make conditional formatting find and show duplicates.
  • And more...

If you do not take advantage of Excel's conditional formatting, you are missing crucial skills.

Enroll in Master Excel's Conditional Formatting Course!

Learn how to take the full advantage of conditional formatting in your everyday work.

abu huda Financial Analyst at Weston Food Company, Canada

It's very helpful for my professional improvement. I like that you explain step by step. I had experience on conditional formatting but, I was always confused that in which option should I use in which condition of conditional format. I was lucky that I took your course. Thank you so much for your extraordinary help.

Rick Sadler

I think this is one of the best courses I have taken. Igor is one of the best explainers of Excel and he walks through both the how and why of each process. I feel I have gained a solid understanding of Excel. When procedures are explained in a way that illustrates the reasons for the steps involved, and not just showing quickly how it is done, one can comprehend the material and retain more information. He did such a thorough job that, even though I know I can refer back to his course, I doubt I will have to. This is a terrific course and I highly recommend it.

Dylan Reneau Finance Officer Ministry of Education

... Your courses are easy to follow and understand and I believe they are structured in a way to urge you along to complete them. Thank you very much your courses were certainly money well spent.

Enroll in Master Excel's Conditional Formatting Course!

Learn how to take the full advantage of conditional formatting in your everyday work.