graphic1

Exam 77-422: Microsoft PowerPoint 2013
3.0 Create Slide Content
3.2 Insert and Format Tables: Import Tables from External Sources (FORMAT the Data in Excel)

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...!

Home ->Styles->Conditional Formatting

graphic2
 

pic1