This browser does not support basic Web standards, preventing the display of our site's intended design. May we suggest that you upgrade your browser?

Microsoft Excel 2008

Working with Conditional Formatting

Conditional formatting rules allow you to format cells depending on how their data relates to other data. You can create original rules to format the cells in your workbook. For example, in a list of numbers ranging from 1 to 10, you can format cells with a value of 5 or greater as red. Conditional formatting logs your formatting rules so you can edit, prioritize, and delete rules easily.

return to topCreating a Customized Rule

You can create your own conditional formatting rules by using the Conditional Formatting dialog box.

  1. Select the range of cells to be formatted

  2. From the Format menu, select Conditional Formatting...
    The Conditional Formatting dialog box appears.
    Conditional Formatting dialog box

  3. From the Condition 1 section, select the desired criteria

  4. Click FORMAT...
    The Format Cells dialog box appears.

  5. Make the desired selections

  6. Click OK
    You are returned to the Conditional Formatting dialog box.

  7. OPTIONAL: To add another condition, click ADD>>
    1. From the next condition section, repeat steps 3-6.

  8. Click OK
    The rule is applied to cells which satisfy the criteria.

return to topEditing Rules

You can edit preformatted and original rules. Rules are only editable if they have been applied in a worksheet.

  1. Select the range of cells to be formatted with the conditional formatting you would like to modify

  2. From the Format menu, select Conditional Formatting...
    The Conditional Formatting dialog box appears.
    Conditional Formatting dialog box

  3. Make the desired changes

  4. Click OK
    The desired changes are applied.

return to topDeleting Rules

Once a rule has been applied, it may be deleted.

  1. Select the range of cells to be formatted that you would like to remove the conditional formatting from

  2. From the Format menu, select Conditional Formatting...
    The Conditional Formatting dialog box appears.
    Conditional Formatting dialog box

  3. Click DELETE...
    The Delete Conditional Format dialog box appears.

  4. Select the condition(s) to delete
    NOTE: The option is selected when a checkmark appears.

  5. Click OK
    You are returned to the Conditional Formatting dialog box.

  6. Click OK
    The rule is cleared from the spreadsheet.

Excellence. Our Measure. Our Motto. Our Goal.