Copying Excel 2007 Formatting with Format Painter
How to Hide and Unhide Rows and Columns in Excel 2007
How to Add a Background Image to an Excel 2007 Worksheet

Applying Conditional Formatting in Excel 2007

Excel 2007's conditional formatting lets you change the appearance of a cell based on its value or the value of another cell. You specify certain conditions, and when those conditions are met, Excel applies the formatting that you choose. You might use conditional formatting to locate dates that meet a certain criteria (such as falling on a Saturday or Sunday), to call out highest or lowest value in a range, or to indicate values that fall under or over a specified amount.

1

Select the cell(s) to which you want to apply conditional formatting.

In most cases, you will select a single column of data in a table rather than an entire table.

2

Click the Conditional Formatting button in the Styles group on the Home tab.

A menu appears with several different options for specifying the criteria.

3

Point to Highlight Cells Rules and then select the criteria you want to use.

Criteria options include Greater Than, Less Than, Between, Equal To, Text That Contains, A Date Occurring, and Duplicate Values. A dialog box opens, where you can specify the value.

4

Enter the values you want to reference in the text box.

You can type a value here, such as 500, or you can reference a cell address, such as F12 for a reference relative to the first active cell, or $F$12 (an absolute reference) to have the conditional formatting for all the selected cells refer to the same cell.

5

Click the drop-down arrow next to the format options and select the desired formatting.

Live Preview shows you what your data will look like. Click the Custom Format option if you want to create your own formatting selections.

6

Click OK.

The cells that meet the specified criteria now appear with the chosen formatting options.

To clear conditional formatting, select the formatted cells and then click the Conditional Formatting button on the Home tab. Point to Clear Rules and then select Clear Rules from Selected Cells.

  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus
Applying a Table Style to an Excel 2007 Table
Adding a Standard Header or Footer in Excel 2007
Previewing Excel 2007 Formatting with Live Preview
Hiding and Unhiding Excel 2007 Worksheets
Renaming an Excel 2007 Worksheet
Advertisement

Inside Dummies.com