Microsoft Office Tutorials and References
In Depth Information
Adding a Pointer to the Data Table Using Conditional Formatting
Save button
range B8:E23
has light border
on right side of
each column
range B8:E8
has light
bottom border
entries in data
table formatted to
Currency style with
two decimal places
light red
background
Figure 4–28
Adding a Pointer to the Data Table Using
Conditional Formatting
If the interest rate in cell E2 is between 4.50% and 7.75% and its decimal portion is a
multiple of 0.25 (such as 6.25%), then one of the rows in the data table agrees exactly
with the monthly payment, interest paid, and total cost in the range E4:E6. For example,
in Figure 4–28, row 15 (5.75%) in the data table agrees with the results in the range E4:
E6, because the interest rate in cell B15 is the same as the interest rate in cell E2. Analysts
often look for the row in the data table that agrees with the input cell results.
Conditional
Formatting
You can add as many
conditional formats
to a range as you like.
After adding the fi rst
condition, click the
Conditional Formatting
button on the Home
tab on the Ribbon and
then click New Rule to
add more conditions. If
more than one condition
is true for a cell, then
Excel applies the formats
of each condition,
beginning with the fi rst.
 
 
Search JabSto ::




Custom Search