O'Reilly logo

Picture Yourself Learning Microsoft® Excel® 2010 by Laurie Ulrich Fuller, Deidre Hayes, Jeffery A. Riley

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

Applying Conditional Formatting

CONDITIONAL FORMATTING isn’t really as complicated as some people think. It’s simply formatting that’s applied when certain conditions are met. Excel 2010 has expanded its powers, however, allowing all sorts of graphical enhancements to be added to your worksheets, but at its core, it’s a simple feature—define what the conditions are (such as “Sales greater than $5,000,000”) and tell Excel how to format the numbers that meet that criteria (make them bold and turn them green, for example).

Creating Cell Rules

The “rules” for conditional formatting are really just a set of criteria, or conditions, that all the cells in a selection are compared to. The cells that meet the conditions are then formatted according ...

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