Problem 16.6

1. select the set of rows you want to conditionally format to alternate be normal or shaded.

2. Click on the format menu and choose "conditional formatting ."

3. Click plus button to add a new rule

4. change the style to adda new rule

5. change the field to "use a formula to determine which cells to format."

6. insert this formula: =mod(row(),20.

7. change the "format with" field to "custom format"

8. Select a medium shade of gray

9. Click OK to close "format Cells window you used to select the gray fill

10. Click OK to close the "new formatting rule" window

11. click OK to close the "manage rules window"

B.

Improve tabular displays by adding "traffic Lights " or other icons in column B (along with the number) to indicate status in terms of "red"= definitely a negative trend, "yellow "=warning , and "green" = definitely a positive trend for sales , sales returns, and the cost of goods sold.

a. For sales: green means that this years sales are larger than last years ; yellow means that this years sales are at least 98% of the prior years; red otherwise

b. For sales returns; Green means that returns are less than 3.5% of sales; yellow means between 3.5% and 4% of sales ; red means 4% of sales or more

c. For operational expenses , green means less than last year ; yellow means less than a 3% increase; red means more than 3% increase over the prior year.

HINT

use the "conditional formatting" toolbar to select :new rule" and then select "icons sets ".

You want to change the rule "type" to format so that you can then compare the value in column B to the other columns