O'Reilly logo

Office 2013 In Depth by Joe Habraken

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

Using Conditional Formatting

So far we approach cell formatting from a static viewpoint; any formatting applied to cells was our job, even in cases where we wanted to highlight certain cells because of their contents using cell formatting. Conditional formatting provides a more dynamic (and often useful) way to use formatting to “point out” cells in a sheet that meet certain conditions. For example, if you want to format all the monthly sales totals in a sheet that fall below a certain conditional amount, you can use conditional formatting to do just that. The cells that meet the condition you set could be formatted with any of the cell-formatting attributes we have discussed. In the example we are discussing, a condition could state that all ...

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