You can apply conditional formatting to a cell so that the cell looks different, depending on its contents. This chapter explores conditional formatting, one of Excel’s most versatile features. Reviewing the Available ActiveX Controls.Understanding the Different Web Formats.Working with External Reference Formulas.Using Formulas for Data Validation Rules.Types of Validation Criteria You Can Apply.Displaying a Sparkline for a Dynamic Range.User Interface Choices for Modifying Chart Elements.Understanding the Dimensions of an Array.Conditional Sums Using Multiple Criteria.Conditional Sums Using a Single Criterion.Creating Custom Views of Your Worksheet.Preventing Certain Cells from Being Printed.Copying Page Setup Settings across Sheets.Adding a Header or Footer to Your Reports.Using Named Styles for Easier Formatting.
0 Comments
Leave a Reply. |