Microsoft Office Tutorials and References
In Depth Information
Extend Your Knowledge
1. Save the workbook using the fi le name, Extend 5-1 Jensen Basketball Poles Complete. Select the
range B20:F20. Click the Conditional Formatting button on the Home tab on the Ribbon and
then click New Rule. When Excel displays the New Formatting Rule dialog box, select ‘Format
only top or bottom ranked values’ in the Select a Rule Type list. In the ‘Format values that rank in
the’ area, type 1 in the center text box. Click the Format button in the Preview area. When Excel
displays the Format Cells dialog box, click the Fill tab, click the green color (column 5, row 7) in the
Background Color area, and then click the OK button. Click the OK button in the New Formatting
Rule dialog box.
2. With the range B20:F20 selected, add a second rule to the range following the procedure from Step 1.
When creating the new rule, select Bottom in the ‘Format values that rank in the’ list and type 1 in
the center text box. Click the Format button and then select the red color (column 2, row 7) in the
Background Color area. Click the OK button in the Format Cells dialog box and then click the OK
button in the New Formatting Rules dialog box.
3. With the range B20:F20 selected, click the Conditional Formatting button on the Home tab on
the Ribbon and then click Manage Rules to view the rules for the range. Click the Close button in
the Conditional Formatting Rules Manager dialog box.
4. Select the range B24:F24. Add a new conditional formatting rule to format all cells based on their
values. Select the Data Bar format style. Select Red, Accent 1, Darker 25% (column 5, row 5) in
the Bar Color palette and then close the New Formatting Rule dialog box.
5. With range B24:F24 selected, add a new conditional formatting rule. Select ‘Format only cells that
contain’ as the rule type. Format only cells with a cell value less than zero. Do not select a format
using the Format button. Make sure that the Preview area indicates that no format is set and then
click the OK button to add the rule.
6. With the range B24:F24 selected, click the Conditional Formatting button on the Home tab on
the Ribbon and then click Manage Rules to view the rules for the range. Click the Stop If True
check box for the fi rst rule in the dialog box to ensure that the second rule is not applied to nega-
tive values in the range (Figure 5–73). Click the OK button to close the Conditional Formatting
Rules Manager dialog box.
7. 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. Change the
print orientation to landscape. Print the worksheet using the Fit to option. Save the workbook.
8. Select the range B15:F19. Click the Conditional Formatting button on the Home tab on the
Ribbon, point to Color Scales on the Conditional Formatting menu, and then click Green –
Yellow – Red Color Scale in the Color Scales gallery. Print the worksheet using the Fit to option.
Do not save the workbook. Submit the assignment as requested by your instructor.
 
Search JabSto ::




Custom Search