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.