7. Advanced Formatting
In this chapter, you’ll find out how to set up formatting that changes as the data changes. You’ll see how you can use themes to provide consistency in design between workbooks. Topics in this chapter include the following:
→ Creating custom number formats
→ Highlighting duplicate values in a list
→ Ensuring consistency with themes and cell styles
Custom formats allow you to create your own number formats, such as including text in a cell but still allowing calculations. With conditional formatting, you can apply a variety of formatting to data that automatically changes as ...
Get My Excel 2016 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.
