In this lesson we cover all the options for applying conditional formats to a workbook. Conditional formats are formatting rules that we can apply so when a cell’s number changes, the format will change automatically.

This is an excellent feature to use to draw a user’s attention to outlying numbers, problem areas or to give a quick visual summaries of the data. We will cover:

• Highlight Cell Rules
• Top/Bottom Rules
• Data Bars
• Color Scales
• Icon Sets
• Using Formulas

In all the above, we will also go into how to customize all the options to make any report automatically update itself according to the criteria we set.

Follow Along Workbooks

If you already have the book and you are looking for the follow along workbooks. Input your information below and I will send it to you in a few minutes. I won’t spam you. I send email tips and tricks every few weeks and I let you know when a new lesson is published. That’s all.

If you don’t see the sign up form below, try disabling any ad blockers. I promise you the form is there.

Enter your name and email below to get your follow along workbook