O'Reilly logo

My Excel 2016 by Tracy Syrstad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

7. Advanced Formatting

Image

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required