Microsoft Office Tutorials and References
In Depth Information
Changing the appearance of data
When icon sets were introduced in Excel 2007, you could apply an icon set as a whole, but
you couldn’t create custom icon sets or choose to have Excel 2007 display no icon if the
value in a cell met a criterion. In Excel 2013, you can display any icon from any set for any
criterion or display no icon.
When you click a color scale or icon set in the Conditional Formatting Rules Manager and
then click the Edit Rule button, you can control when Excel applies a color or icon to your
IMPORTANT Be sure that you do not include cells that contain summary formulas in your
conditionally formatted ranges. The values, which could be much higher or lower than your
regular cell data, could throw off your comparisons.
In this exercise, you’ll create a series of conditional formats to change the appearance of
data in worksheet cells that display the package volume and delivery exception rates of a
regional distribution center.
SET UP You need the Dashboard workbook located in the Chapter04 practice file
folder to complete this exercise. Open the workbook, and then follow the steps.
Select cells C4:C12 .
On the Home tab, in the Styles group, click Conditional Formatting . On the menu,
point to Color Scales , and then in the top row of the palette, click the second pattern
from the left to apply the format to the selected range.