Using Conditional Formatting

Use conditional formatting in Excel to make data easier to read. Use the Excel conditional formatting function to better visualize data too.

Introduction

Conditional Formatting Let's imagine you have a spreadsheet with thousands of rows of data. It would be extremely difficult to see patterns and trends just from examining the raw data. Excel gives us several tools that will make this task easier. One of these tools is called conditional formatting. With conditional formatting, you can apply formatting to one or more cells based on the value of the cell. You can highlight interesting or unusual cell values, and visualize the data using formatting such as data bars.

In this lesson, you will learn how to apply, modify, and delete conditional formatting rules.

Conditional formatting

The conditional formatting options

You have many conditional formatting rules, or options, you can apply to cells in your spreadsheet. Each rule will affect selected cells differently. Before you choose a formatting rule, you must identify what questions you are trying to answer. For example, in a sales spreadsheet you might want to identify the salespeople with lower than average sales. To do this, you need to choose a conditional formatting rule that will show you this answer. Not all of the options will provide you with this information.

Some of the conditional formatting options include:

Highlight Cell Rules
Highlight Cell Rules
Highlight Cell Rules
Highlight Cell Rules
Highlight Cell Rules
Highlight Cell Rules

To apply conditional formatting:

Conditional Formatting
Conditional Formatting

To remove conditional formatting rules:

To manage conditional formatting rules:

Conditional Formatting

Challenge!

Use the Company Sales workbook to complete this challenge.