Microsoft Office Tutorials and References
In Depth Information
Extend Your Knowledge EX 147
Figure 2–85
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.
Applying Conditional Formatting to Cells
Instructions: Start Excel. Open the workbook Extend 2-1 Biology 201 Midterm Scores. 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 fi les required in this topic. Perform the following tasks to apply new
conditional formatting to the worksheet.
1. Select the range C4:C18. Click the Conditional Formatting button on the Home tab on the
Ribbon and then select New Rule in the Conditional Formatting gallery. Select 'Format only top
or bottom ranked values' in the Select a Rule Type area (Figure 2–86). Enter a value between 20
and 35 of your choosing in the text box in the Edit the Rule Description area and click the ‘% of
selected range’ check box to select it. Click the Format button and choose a format to assign to this
conditional format. Click the OK button in each dialog box to close the dialog boxes and view the
worksheet.
2. With range C4:C18 selected, apply a
conditional format to the range that highlights
scores that are below average.
3. With range D4:D18 selected, apply a
conditional format to the range that highlights
any grade that is a D or an F.
4. With range B4:B18 selected, apply a
conditional format to the range that uses a red
color to highlight any duplicate student names.
5. Change the document properties, as specifi ed
by your instructor. Change the worksheet
header with your name, course number,
and other information requested by your
instructor. Save the workbook using the fi le
name, Extend 2-1 Biology 201 Midterm
Scores Complete, and submit the revised
workbook as specifi ed by your instructor.
Figure 2–86
C6161_EXC_02.4c.indd 147
C6161_EXC_02.4c.indd 147
3/6/07 3:30:12 PM
3/6/07 3:30:12 PM
Search JabSto ::




Custom Search