Microsoft Office Tutorials and References
In Depth Information
To Add a Pointer to the Data Table
New Formatting
Rule dialog box
2
Click New Rule on
the Conditional
Formatting menu.
When Excel displays
the New Formatting
Rule dialog box,
click ‘Format only
cells that contain’
in the Select a Rule
Type box. Select Cell
Value in the left list
in the ‘Format only
cells with’ area and
then select equal to
in the middle list.
interest rate
in cell E2
relational
operator
represents each
cell in selected
range B10:B23
Format button
white font on green
background assigned to
any cell if its value equals
interest rate in cell E2
OK button
Type =$E$2 in the
right box.
Click the Format
button, click the Fill
tab, and then click
Green (column 5,
row 7) on the
Background color
palette.
Figure 4–30
Click the Font tab, click the Color box arrow, and then click White (column 1, row 1) on the
Color palette in the Theme area.
Click the OK button in the Format Cells dialog box to display the New Formatting Rule dialog
box as shown in Figure 4–30.
3
Click the OK
button in the New
Formatting Rule
dialog box. Click
cell G23 to deselect
the range B10:B23
(Figure 4–31).
How does Excel
apply the conditional
formatting?
Cell B15 in the data
table, which contains
the value, 5.75%,
appears with white
font on a green
background, because
the value 5.75%
is the same as the
interest rate value in
cell E2.
cell entry is white
font on green
background
because value in
cell B15 equals
value in cell E2
Figure 4–31
 
 
Search JabSto ::




Custom Search