Microsoft Office Tutorials and References
In Depth Information
A formula in a cell can display a variety of values, depending on the data that
the formula receives. Because a formula can display any type of a number,
you might want to use conditional formatting as a way to highlight certain
types of values.
Suppose you have a formula that calculates your monthly profits. You can
change the formatting to emphasize the results:
If your result is zero or a loss, display that value in red.
If you make a profit under $1,000, display that value in yellow.
If the profit is at least $100,000, display that value in green.
Conditional formatting simply displays data in a formula in various ways,
depending on the value that the formula calculates.
Comparing data values
The simplest type of conditional formatting displays different colors or icons
based on adjacent values, which makes it easy to compare, at a glance,
Excel offers three types of conditional formatting for identifying values, as
shown in Figure 9-6:
Data Bars: Higher values display more color while lower values display
Color Scales: Different colors identify different ranges of values.
Icon Sets: Different icons identify different ranges of values.
To apply conditional formatting, follow these steps:
1. Select the cells that you want to apply conditional formatting.
2. Click the Home tab and then click the Conditional Formatting icon in
the Styles group.
A menu appears (refer to Figure 9-6).
3. Move the mouse over Data Bars, Color Scales, or Icon Sets.
A menu appears.