O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

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

Formatting Conditionally

You probably are asking yourself, “What is formatting conditionally?” Formatting conditionally lets you apply special formatting settings that take effect when the contents of a cell meet specified conditions. For instance, if the values fall below a specific number, you can show those values in bold pink, and if the values are greater than a specific number, you can display those values in bold blue. Excel's Conditional Formatting command helps you easily format your values based on specific conditions.

In the upcoming To Do exercise, you step through the process of setting up conditional formatting for values on the Summary sheet in the Sales workbook.

To Do: Format Values Conditionally

1.
Select the cells that contain ...

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