O'Reilly logo

Take Control of Numbers by Sharon Zardetto

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

Cell Formats

“Format” is a nebulous word when it comes to spreadsheet cells because it can refer to many different things. Formatting defines the look of a cell: its background fill, borders, and text attributes such as font and color. Formatting also describes how the data itself should look—whether there are dollar signs on the numbers, for instance.

In this chapter, I cover the details of basic cell formats—background fills and borders—and demystify the puzzling interaction between Cell Borders and Grid Lines. I also explain one of my (and soon to be your) favorite features: Conditional Highlighting, where a cell’s formatting changes based on its content.

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