Microsoft Office Tutorials and References
In Depth Information
Formatting the Worksheet EX 121
5
Click the OK button
to assign the
conditional format to the
range J4:J12.
Click cell A18 to
deselect the range
J4:J12 (Figure 2–52).
Excel displays negative
numbers in range J4:J12
with a light red background
Figure 2–52
Conditional Formatting Operators
As shown in Figure 2–49 on page EX 119, the second text box in the New Formatting
Rule dialog box allows you to select a relational operator, such as less than, to use in the
condition. The eight different relational operators from which you can choose for conditional
formatting in the New Formatting Rule dialog box are summarized in Table 2–5.
Conditional
Formatting
You can assign any
format to a cell, a range
of cells, a worksheet,
or an entire workbook
conditionally. If the
value of the cell changes
and no longer meets
the specifi ed condition,
Excel suppresses the
conditional formatting.
Table 2–5 Summary of Conditional Formatting Relational Operators
Relational Operator
Description
Between
Cell value is between two numbers
Not between
Cell value is not between two numbers
Equal to
Cell value is equal to a number
Not equal to
Cell value is not equal to a number
Greater than
Cell value is greater than a number
Less than
Cell value is less than a number
Greater than or equal to
Cell value is greater than or equal to a number
Less than or equal to
Cell value is less than or equal to a number
C6161_EXC_02.4c.indd 121
C6161_EXC_02.4c.indd 121
3/6/07 3:29:15 PM
3/6/07 3:29:15 PM
Search JabSto ::




Custom Search