Microsoft Office Tutorials and References
In Depth Information
Color Scales Two-color or three-color formats whose color indicates the values
in the cells relative to all other adjacent cells formatted using the same conditions.
Choose from a number of different color combinations, based on the current theme.
Icon Sets Sets of three, four, or five tiny graphic images placed inside cells. The icons’
shape or color indicates the values in the cells relative to all other adjacent cells
formatted using the same conditions. Choose from a number of different types of icons.
For example, you could apply conditional formatting to a range of cells that contain sales
totals, specifying that if any of the totals drops to less than $1,000, the format of the cell
changes to stand out from the other cells. To do so, follow these steps:
Select the cells you want to format.
Click Conditional Formatting, Highlight Cells Rules, Less Than to display the Less Than
dialog box shown in Figure 9-21.
Figure 9-21 Select the Less Than rule on the Highlight Cells Rules menu to create a
stoplight chart using conditional formatting.
Type the number you want to use as the threshold for this condition; in this case,
Select one of the options from the drop-down list of available formats.
Notice that when you select a format option from the Highlight Cells Rules menu,
Excel previews it for you on the worksheet. Type a number in the Format Cells That
Are Less Than box, select a format option from the drop-down list, and the preview
adjusts accordingly. Clicking the Custom Format option at the bottom of the list
displays a version of the Format Cells dialog box with the Number, Font, Border, and Fill