Microsoft Office Tutorials and References
In Depth Information
The Trend column contains a formula that references the Change column. I used the
Show Icon Only option in the Trend column, which also centers the icon in the column.
In some cases, using icon sets can cause your worksheet to look very cluttered. Displaying an icon for every cell
in a range might result in visual overload.
Figure 19-13 shows the test results table after hiding the level arrow by choosing No Cell Icon in the Edit For-
matting Rule dialog box.
Figure 19-13: Hiding one of the icons makes the table less cluttered.
Creating Formula-Based Rules
Excel's conditional formatting feature is versatile, but sometimes it's just not quite versatile enough. Fortunately,
you can extend its versatility by writing conditional formatting formulas.
The examples later in this section describe how to create conditional formatting formulas for the following:
• To identify text entries
• To identify dates that fall on a weekend
• To format cells that are in odd-numbered rows or columns (for dynamic alternate row or columns shading)
• To format groups of rows (for example, shade every group of two rows)