Exam 77-427 Microsoft Excel 2013 EXPERT
2. Apply Custom Formats and Layouts
2.2 Apply Advanced Conditional Formatting and Filtering: Use Functions To For
mat Cells

graphc1

Home-> Styles-> Conditional Formatting-> Data Bars

 

Data Bars

The following exercises demonstrate the various Conditional Formatting available in Microsoft Excel. All of these examples will be applied to the H Column, the one with sales data. The Amount has been Sorted Descending.

 

Try It: Format with Data Bars

Select Column H.

Go to Home -> Styles.

Go to Conditional Formatting.

Select: Data Bars.

 

What Do You See? The cell with the highest value is 100% filled in. The other cells are filled with less than 100%. Excel calculates the percentage.

 

 

After each trial, select the H Column.
Go to Conditional Formatting -> Clear Rules -> From the Selected Cells.