Conditional Formatting

Another useful formatting tool is conditional formatting. That means telling the spreadsheet that if a certain condition is true, then it should format the cell in a certain way.

I most commonly use it to make zeros disappear. By telling it to change the font color to match the background whenever the value in the cell is zero, I can make the non-zero entries in a table stand out much more clearly.
Continue reading Conditional Formatting


The easiest way to change the formatting on a table or cell in a spreadsheet, if you’re not feeling too picky about the results, is to use ‘Autoformat’, ‘Table/Cell Styles’, ‘Themes’, or whatever automatic formatting option your program gives you. This will usually set the background, the font color/size, alignment and the borders of the cells. It usually won’t merge or combine cells If you do it across a whole table it will often use different options for different rows. Continue reading Autoformatting

Cell & table formatting

I was recently asked for ideas on how to present statistics. It’s a good question because, let’s face it, people don’t like numbers. They want information that’s easy to digest…and, almost more importantly, they want information that LOOKS like it’s easy to digest. Just like the cover of a book, something visually attractive can generate more interest than something plain can, even if the contents are the same. Continue reading Cell & table formatting