Chapter 20Chapter 20
Formatting
Worksheets with
VBA
Performing Basic Formatting Tasks with VBA + Format-
ting Numbers + Formatting Text + Formatting Dates +
Formatting Columns and Rows + Formatting Headers and
Footers + Formatting Cell Appearance + Removing For-
matting from Cells and Ranges + Performing Advanced
Formatting Tasks with VBA + Conditional Formatting
Using VBA + Conditional Formatting Rule Precedence +
Deleting Rules with VBA + Using Data Bars + Using Color
Scales + Using Icon Sets + Formatting with Themes +
Formatting with Shapes + Formatting with Styles +
Chapter Summary
507
Microsoft Excel has always provided users with a fairly comprehensive ...
Get Excel 2007 VBA Programming with XML and ASP now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
