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.

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