Format the Data

Conditional Formatting changes the Shading depending on the value in the cell.

 

7. Try it: Use Conditional Formatting

Select Cells B2:B6.

Go to Home ->Styles.

Click on Conditional Formatting.

Select: Data Bars.

 

The Conditional Formatting includes:

Highlight Cell Rules

Top/Bottom Rules

Data Bars

Color Scales

Icon Sets

New Rule

Clear Rule

Manage Rules

 

Yep, Conditional Formatting helps your audience visualize the numbers.

 

Keep going...!

Exam 77-883: Microsoft PowerPoint 2010

4. Creating Charts and Tables

4.1. Construct and modify tables: Format the Spreadsheet

Home ->Styles->Conditional Formatting