Microsoft Office Tutorials and References
In Depth Information
5. Click OK.
Figure 9-22 shows a table after applying conditional formatting. This example was
formatted using two highlight cells conditions: one format for numbers greater than 9,000 and a
different format for numbers less than 1,000.
Figure 9-22 We created two conditions—one to lag high values and one to lag low values.
These guys had a rough January.
You’ll find the SalesByProduct.xlsx file with the other examples on the companion website.
This procedure is essentially the same for all the highlight cells and top/bottom rules, but
several of these rules deserve additional comment:
Between This is obvious perhaps, but although the Greater Than, Less Than,
and Equal To rules require you to type a single number criterion, the Between rule
requires two criteria.
Text That Contains When you choose this rule, cells containing any form of the
text string you type as a criterion are highlighted (entering “and” highlights cells
containing sand, Andrew, and so on).
A Date Occurring This rule always uses the current date as the point of reference.
The “occurring” options are all relative to this: Yesterday, Last Week, Next Month, and
This rule actually has two options, highlighting either duplicate
or unique values.