Use Excel Conditional Formatting to Enhance Data Analysis

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

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.

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!

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.