Microsoft Office Tutorials and References
In Depth Information
Changing the appearance of data
In that dialog box, click the Format button to display the Format Cells dialog box. After you
define your format, click OK to display the rule.
IMPORTANT Excel doesn’t check to make sure that your conditions are logically consistent,
so you need to be sure that you plan and enter your conditions correctly.
Using Excel, you can also create three other types of conditional formats: data bars, color
scales, and icon sets. Data bars summarize the relative magnitude of values in a cell range
by extending a band of color across the cell.