Join my community of over 6,700 students learning my courses!
This course has been updated in March 2017
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:
Other benefits from taking this course:
Click the “Take this course" button at top right corner. Without the knowledge of conditional formatting you are missing awesome opportunities.
Two more examples how I have used conditional formatting
Short video explaining what you should know before you take this course about Microsoft Excel
Small reminder how to improve the user experience with Udemy.
In this lecture I am talking about how to highlight cells based on greater than a value.
Learn how to highlight cells with values less than a certain value.
Learn how to use between function. in conditional formatting.
In this lecture you will learn about the equal to function in conditional formatting.
In this lecture you will learn about text that contains function in conditional formatting.
You will learn about highlight cell rule called "A Date Occurring"
In this lecture you will learn about highlighting cells with either duplicate values or unique values.
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.
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 %.
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.
In this lecture you will be taught about both types of data bars, which are gradient and solid fills.
Short introduction about icon sets and how the amount of icon affect the results of the conditional formatting.
Explanation of directional icon sets in conditional formatting.
In this lecture you will lean about shapes and indicators under icon sets in conditional formatting.
In this lecture you will lean about ratings under icon sets in conditional formatting.
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.
How you can use conditional formatting together with filters in order to find the data you want to analyze.
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.
This lecture will teach you about the menu of the custom formulas for conditional formatting.
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.
This lecture will teach you how you can highlight cells with time information using custom formulas.
In this lecture we will cover how you can create custom icon set ranges rather than using the presett.
Instead of only highlighting the cells in the columns, you will learn how to highlight the whole row based on one 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.
In this lecture you will learn how to compare two lists either for matches or mismatches, depending on your choice.
Learn how to change the colours of the alternating rows.
Rather than using presets, learn how to write formula for finding duplicates.
There are cases, where you need to compare subtotals. Conditional formatting is perfect for that.
Other Excel courses I have created.
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 7 million viewers on my main channel, increasing by 200,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 2,200 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.
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.