Microsoft Office Tutorials and References
In Depth Information
Important Be sure to 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 displaying the package volume and delivery exception rates of a
regional distribution center.
SET UP You need the Dashboard_start workbook located in your Chapter04 practice
file folder to complete this exercise. Open the Dashboard_start workbook, and save it
as Dashboard . Then follow the steps.
1. Select cells C4:C12 .
2. 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.
Excel formats the selected range.
3. Select cells F4:F12 .