
Chapter 4 Working with Conditions88
Conditional Formatting
The conditional formatting feature of Excel allows us to quickly format cells accord-
ing to certain conditions. For example, it is possible to specify that a negative number
in a particular cell, for instance, the cell showing net income after expenses, should
appear in red. There are two main uses of conditional formatting. First, it is used to
highlight certain cells based on their content to draw the attention of people examining
a worksheet. For example, you have prepared a worksheet showing daily sales of differ-
ent stores in your company. You may use conditional formatting to