Take Control of Numbers, 3rd Edition

Learn About Cell Formats

“Format” is a nebulous word when it comes to table cells because it can refer to different things. A cell’s format defines its look, such as its background fill and border color and thickness. A cell’s format also describes how its data should look—such as whether there are dollar signs on numbers.

In this chapter, I cover the details of basic cell formats—background fills and borders—and demystify the sometimes puzzling interaction between Cell Borders and gridlinesCell Borders I also explain one of my (and soon to be one of your) favorite features in Use Conditional Highlighting, which explains how to apply cell formatting that changes based on a cell’s content.

Apply Basic Cell Formats

You can use ...