Microsoft Office Tutorials and References
In Depth Information
Formatting—With Conditions
Figure 4–108. Where to customize a conditional format
to a modified Format Cells dialog box, which enables you to ascribe your own collection of formats to
cells meeting your condition (note, however, that you can’t change the font).
A n d on ce y ou un de r sta n d how Le ss T ha n … wor k s, y ou’ l l se e tha t the Greater Than… Between…, ,
and Equal To... Conditional Formats work identically, with the obvious proviso that you specify a
number Greater Than a particular value, or numbers between two selected values ( including those two
values), or a value Equal To one particular number, respectively. Text That Contains... works in a
comparable way too, requiring that the user name a specific word or phrase that must appear in
selected cells before the Conditional Formats kick in (and they’re not case-sensitive). A Date
Occurring when clicked yields this drop down (Figure 4–109):
Figure 4–109. Establishing a date-based rule
Duplicate Values is a useful option that lets you format either all the values in a range that appear
mor e than on ce, or all unique values—values that appear only once (Figure 4–110):
Search JabSto ::

Custom Search