Microsoft Office Tutorials and References
In Depth Information
✓ Clear Rules opens a continuation menu where you can remove
conditional formatting rules for the cell selection by clicking the Clear Rules
from Selected Cells option, for the entire worksheet by clicking the Clear
Rules from Entire Sheet option, or for just the current data table by
clicking the Clear Rules from This Table option.
✓ Manage Rules opens the Conditional Formatting Rules Manager dialog
box where you edit and delete particular rules as well as adjust their
rule precedence by moving them up or down in the Rules list box.
Formatting with scales and markers
The easiest conditional formatting that you can apply to a worksheet cell
range is using the pop-up palettes of graphical scales and markers attached
to the Data Bars, Color Scales, and Icon Sets options on the Conditional
Formatting button’s drop-down menu:
✓ Data Bars represent the relative values in the cell selection by the length
of the color bar in each cell and are great for helping you quickly spot
the lower and higher values within a large range of data.
✓ Color Scales classify the relative values in a cell selection with a color
gradation using a one-, two-, or three-color scale and are great for
identifying the distribution of values across a large range of data.
✓ Icon Sets classify the values in the cell selection into three to five
categories and each icon within the set represents a range of values that go
from high to low. Icon sets are great for quickly identifying the different
ranges of values in a range of data.
Figure 3-19 shows you an example of cell ranges (containing identical values)
using each of the three formatting types. The values in the first range
(B2:B12) are conditionally formatted using blue Gradient Fill Data Bars. The
values in the second range (D2:D12) are conditionally formatted using the
Green, Yellow, Red Color Scale. The values in the third range (F2:F12) are
conditionally formatted using the 3 Arrows (Colored) Icon Set.
In Figure 3-19, the particular conditional formatting types Excel assigned to
each cell range can be interpreted as follows:
✓ Data bars added to the cells in the first cell range, B2:B12, represent the
relative size of its values graphically, much like a standard bar chart.
✓ Color scale applied to the second range, D2:D12, represent the relative
size of the values in the range by color and hue (red hues applied to the
lower values, yellow to the middle values, and green to the higher values).