Part I: Getting Started with Excel
This workbook, named color scale example.xlsx, is available on this book’s website at http://www.
wiley.com/go/excel2019bible.
Excel provides six two-color scale presets and six three-color scale presets, which you can
apply to the selected range by choosing Home ➪ Styles ➪ Conditional Formatting ➪ Color
Scales.
To customize the colors and other options, choose Home ➪ Styles ➪ Conditional Formatting
➪ Color Scales ➪ More Rules, and the New Formatting Rule dialog box, shown in Figure
5.13, appears. Adjust the settings, and watch the Preview box to see the effects of your
changes.
FIGURE 5.13
Use the New Formatting Rule dialog box to customize a color scale.
Using icon sets
Yet another conditional formatting option is to display an icon in the cell. The icon displayed
depends on the value of the cell.
