Microsoft Office Tutorials and References
In Depth Information
Formatting—With Conditions
Figure 4–123. Changing the conditional formatting rules
Click Edit Rule… and observe the dialog box shown in Figure 4–124:
Figure 4–124. Rules are made to be…edited
This is a wide-ranging dialog box that contains numerous options, but for now we’re interested in
changing the icon numbers —the score thresholds at which the pies blacken more or less. Note the
defaults about which we’ve already spoken.
Moreover, we see that the Select a Rule Type area in the Edit Formatting Rule di al og box l e ts y ou
cha n g e y our r ul e completely ; if for example I select Format only values that are above or below average,
I’ll be brought here (Figure 4–125):
Search JabSto ::

Custom Search