Formatting a Worksheet

1. Formatting a Worksheet 1

2. Formatting a Worksheet 2

3. Formatting a Worksheet 3

4. Formatting a Worksheet 4

5. Formatting a Worksheet 5

6. Formatting a Worksheet 6

7. Formatting a Worksheet 7

8. Formatting a Worksheet 8

9. Formatting a Worksheet 9

10. Formatting a Worksheet 10

11. Formatting a Worksheet 11

12. Formatting a Worksheet 12

13. Formatting a Worksheet 13

14. Formatting a Worksheet 14

15. Formatting a Worksheet 15

16. Formatting a Worksheet 16

17. Formatting a Worksheet 17

18. Formatting a Worksheet 18

19. Formatting a Worksheet 19

20. Formatting a Worksheet 20

21. Formatting a Worksheet 21

22. Formatting a Worksheet 22

23. Formatting a Worksheet 23 Conditional Formatting Select the cells to which you want to apply the conditional formatting Select Conditional Formatting from the Format Menu. Be sure the Cell Value Is is selected in the Conditional 1 Drop-down box on the left of the dialog box In the next drop-down box to the right, select the conditions. After selecting the condition, you must fill in a value or specify a cell or cells in the worksheet that Excel can use as a reference for the conditional formatting Click the Expand button on the Conditional Formatting dialog box to expand the dialog box Click the Format button on the Conditional Formatting dialog box and select the formatting options for the condition you specified in the dialog box After setting the conditions to be met, click OK