2007 Microsoft® Office System Plain & Simple

Automatically Highlighting Certain Data

When you use conditional formatting, you can tell Excel to apply specific formatting to any cells that meet the specific criteria you’ve set. For example, you can tell Excel to format a cell whenever the number of sales falls below a certain minimum or whenever the cost rises above a certain figure. Excel will apply the cell formatting only when the conditions you set are found to be true.

Set the Conditional Formatting

1. Select the cells, columns, or rows to which the formatting will apply.

2. On the Home tab, click ...