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

Emphasizing the top 10

Highlighting duplicate values in a list

Ensuring consistency with themes and cell styles

Creating hyperlinks

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 live online training, plus books, videos, and digital content from nearly 200 publishers.