September 2021
Intermediate to advanced
282 pages
6h 1m
English
“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.
You can use cell borders and ...
Read now
Unlock full access