Microsoft® Office Excel 2003 Inside Out

Chapter 9. Advanced Formatting and Editing Techniques

• Applying Conditional Formats

• Formatting with Styles

• Using Template Files to Store Formatting

• Auditing and Documenting Worksheets

• Outlining Worksheets

• Consolidating Worksheets

This chapter introduces a number of features designed to assist you in turning your data into effective information. These techniques are more involved and more powerful than those discussed in Chapter 7 and Chapter 8, and they might be among the most useful tools you'll use. In this chapter, we'll cover applying conditional formats, creating and using styles and templates, outlining your worksheets, and using Excel's built-in auditing features.

Applying Conditional Formats

Choosing Format, Conditional Formatting offers an easy ...