Select Page

Conditional Formatting

Conditional Formatting is a great way to create dashboards in Excel that automatically change colors and icons based on your data. Conditional Formatting is also very helpful when reviewing new data. You can quickly and easily focus on the most important trends or outliers in your data. Watch this series of Excel Videos and read the four articles below, then test your knowledge with the sample spreadsheet used in the articles. By the time you finish, you’ll be well on your way to mastering Conditional Formatting.

Conditional Formatting Spreadsheet

Here’s the sample Conditional Formatting spreadsheet referenced in the articles.

Conditional Formatting Part 1 article

Conditional formatting is a powerful tool built into Excel that allows you to automatically format cells based on their contents.

Conditional Formatting Part 2 article

Now that you are familiar with the Highlight Cells rules and some of the formatting options available, take your Excel skills to the next level by working through these examples.

Conditional Formatting Part 3 article

Color Scales are an easy way to convey the range of your data using color gradations.

Conditional Formatting Part 4 article

Now that we are familiar with Conditional Formatting, we will add Icon Sets to make your spreadsheets even more informative.