336 Chapter 11 Change Workbook Appearance
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 Chapter11 practice
file folder to complete this exercise. Open the Dashboard_start workbook, and save it
as Dashboard. 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.
Excel formats the selected range.
Color Scales conditional formatting applied to the first data range.- Select cells F4:F12.