Excel Conditional Formatting

Virtually everyone knows that you can use Excel to store and calculate values. Just about as many people also know that you can format the information stored in a worksheet. You can control all sorts of ways that the information in a cell (or range of cells) is displayed—change the font size, the weight of the font, the color used, how many decimal places it uses, its alignment in the cell, and on and on.

What if you wanted the way that a cell appears to be based on some condition, however? For instance, you might want the text in a cell to be bold if the value is above some threshold or you might want the typeface to be red if the value is negative. This is where conditional formatting comes into play—the application of formats based upon criteria that you specify.

The conditional formatting capabilities of Excel are impressive and can be very powerful. All you need to do is picture how you want your data to appear, and then figure out the criteria that should be met in order for the formatting to be applied. Whenever the values change on which your conditional formatting is based, Excel changes the formatting to reflect those changed values.

To make conditional formatting even more powerful, Excel allows you to define multiple criteria to be applied to a cell or range of cells. Each criterion can have different formatting characteristics associated with that criterion. The way in which you can use conditional formatting is limited only by your imagination.

Excel Conditional Formatting discusses how you can start using those conditional formatting capabilities right away. There are two versions of Excel Conditional Formatting: One for users of Excel versions prior to Excel 2007 and another for users of Excel 2007. (Huge changes in the conditional formatting were introduced with the release of Excel 2007.) The Excel 2003 version is over 60 pages in length and the Excel 2007 version is over 80 pages in length!

Regardless of which version you get, you'll discover how easy it really is to apply formatting based upon criteria that you specify. The e-book introduces you to the power of conditional formatting, how to define conditional formats, how to edit them, how to manage them, and how to think "outside the box" when it comes to this type of formatting. Take a look at this table of contents:

Excel 2003 Conditional Formatting		Excel 2007 Conditional Formatting
Introduction A Word about Versions Need More Tips? Sharing this E-Book Conditional Formatting Basics Understanding Conditional Formatting Conditions Using Multiple Test Conditions More than Three Conditional Formats Copying Conditional Formatting Deleting Conditional Formats Finding Cells Containing Conditional Formats Protecting Conditional Formatting Conditionally Formatting Cells Coloring Cells with Formulas Shading a Cell Until Something is Entered Highlighting Values in a Cell Highlighting Cells Containing Specific Text Conditionally Highlighting Cells Containing Formulas Shading Based on Odds and Evens Displaying Negative Percentages in Red Hiding Individual Cells Checking for Messages in Cells Conditionally Formatting Rows Conditionally Formatting an Entire Row Shading Rows with Conditional Formatting Automatic Lines for Dividing Lists Formatting Subtotal Rows Real-World Conditional Formatting Alerts About Approaching Due Dates Pulling All Fridays Conditional Formatting Based on Date Proximity Conditionally Formatting for Multiple Date Comparisons Conditional Formatting for Errant Phone Numbers Changing Excel's Background Color Advanced Considerations Conditional Formats that Distinguish Blanks and Zeroes Counting Colors from Conditional Formats Changing Font Face and Size Conditionally Sorting or Filtering by Conditional Format Results Removing Conditional Formats, but Not the Effects Conditional Formatting with Data Imported from Access Checking All Cell Formatting in VBA		Introduction A Word about Versions Need More Tips? Sharing this E-Book Conditional Formatting Basics Defining a Single Condition Working with Multiple Conditions More than Three Conditional Formats Defining a Rule Based on Cell Values Defining a Rule Based on Cell Contents Defining a Rule Based on Cell Ranking Defining a Rule Based on a Cell’s Relation to Average Defining a Rule Based on Duplicate Status Defining a Rule Based on a Formula Copying Conditional Formatting Deleting Conditional Formats Finding Cells Containing Conditional Formats Protecting Conditional Formatting Conditionally Formatting Cells Coloring Cells with Formulas Shading a Cell Until Something is Entered Highlighting Values in a Cell Highlighting Cells Containing Specific Text Conditionally Highlighting Cells Containing Formulas Shading Based on Odds and Evens Displaying Negative Percentages in Red Hiding Individual Cells Checking for Messages in Cells Conditionally Formatting Rows Conditionally Formatting an Entire Row Shading Rows with Conditional Formatting Automatic Lines for Dividing Lists Formatting Subtotal Rows Real-World Conditional Formatting Alerts About Approaching Due Dates Pulling All Fridays Conditional Formatting Based on Date Proximity Conditionally Formatting for Multiple Date Comparisons Conditional Formatting for Errant Phone Numbers Changing Excel's Background Color Advanced Considerations Conditional Formats that Distinguish Blanks and Zeroes Counting Colors from Conditional Formats Sorting or Filtering by Conditional Format Results Changing Font Face and Size Conditionally Removing Conditional Formats, but Not the Effects Conditional Formatting with Data Imported from Access Applying Conditional Formatting to Multiple Worksheets Checking All Cell Formatting in VBA

In Excel Conditional Formatting you'll find plenty of information about conditional formatting, but it is not the dry, lifeless information you'll often find in computer books. The book zeroes in on what you need to know to understand and put conditional formatting to work right away. You'll also find ideas on how to make conditional formatting fit your needs. You'll discover ways to stretch your knowledge and enhance how you can present the data in your worksheets.

Excel Conditional Formatting is an e-book in Adobe Acrobat (PDF) format. In this format you enjoy the following features:

• The ability to view, search, and print the book.
• Screen shots that illustrate what you see in Excel as you follow the step-by-step instructions.
• The ability to select and copy sections of text, such as macro code.
• Hyperlinks to internal content (in the book itself) and referenced resources on the Web.

Since the electronic book is provided in Adobe Acrobat (PDF) format, you need to either have Acrobat or the free Adobe Acrobat Reader. Many computer systems already have the reader installed. If you do not, you can get it free, directly from Adobe.

Excel Conditional Formatting provides a valuable resource for focused information that can't be matched by any other single source or computer book.

Description	CD		Download
Excel 2007 Conditional Formatting	$24.99		$19.99		(1.8 MB)
Excel 2003 Conditional Formatting	$24.99		$19.99		(1.1 MB)

You can also order Excel Conditional Formatting by calling our order line: 801-607-2035.