Microsoft Office Tutorials and References
In Depth Information
Extend Your Knowledge
Extend the skills you learned in this chapter and experiment with new skills. You may need to
use Help to complete the assignment.
More Conditional Formatting
Instructions: Start Excel. Open the workbook Extend 5-1 Jensen Basketball Poles from the Data Files
for Students. See the inside back cover of this topic for instructions for downloading the Data Files for
Students or see your instructor for information on accessing the ﬁ les required in this topic. You have
been asked to add conditional formatting to highlight the lowest and highest total expenses, and to
add conditional formatting to show data bars for net income that is greater than zero (Figure 5–73).
Complete the following tasks to add and manage conditional formatting rules in the worksheet.
Stop If True
lowest value in
in range B20:
second rule not
applied if ﬁ rst rule’s
condition is true