Designing Conditional Formatting

You can make your worksheets more powerful by setting up conditional formatting. Conditional formatting lets the value of a cell determine its formatting. For example, you might want this year's sales total to be displayed in red and italics if it's less than last year's total, but in green and bold if it's more. The formatting is applied to the cell values only if the values meet the a condition that you specify. Otherwise, no conditional formatting is applied to the cell values.

Establish a Conditional Format

Select a cell or range you want to conditionally format.

Click the Format menu, and then click Conditional Formatting.

Select the operator and values you want for condition 1.

Click the Format button, select the attributes you want applied, and then click OK.

Click Add to include additional conditions, and then repeat steps 3 and 4.

Click OK.

Delete a Conditional Format

Click the Format menu, and then click Conditional Formatting.

Click Delete.

Select the check box for the condition(s) you want to delete.

Click OK.

See Also

See "Formatting Data with Auto Format" on page 106 for information on formatting data more efficiently .