• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL

Chapter 12. Making It Look Good > Conditional Formatting

Conditional Formatting

You might want to apply different formats to different cells, depending on their value or whether they meet some other criteria. You can do this with Excel's conditional formatting feature.

To format cells based on conditions:

Select the cells you want to format (Figure 12.33).

Figure 12.33. Select the cells to format.

Choose Format > Conditional Formatting.

In the Conditional Formatting dialog box, specify from the pull-down menus whether you want to apply the format based on the value of the cell, or some formula (Figure 12.34). If you choose a formula, the formula must begin with an equal sign (=), and the formula must evaluate to either true or false instead of a number. In the language of mathematics, it must be a Boolean expression.

Figure 12.34. When you choose Format > Conditional Formatting, the conditional Formatting dialog box appears. Choose your criteria and formats.

Click the Format button, and in the dialog box that appears, choose the font, border, and pattern formats you want to apply to the cells that meet the criteria.

If you have more than one criterion to apply, click Add in the Conditional Formatting dialog box, then define the second criterion. You may have up to three criteria, and the default format, applied to cells that meet none of the criteria, constitutes a fourth format possibility.

Click OK to apply the conditions. The cells are evaluated and formatted according to your criteria (Figure 12.35).

Figure 12.35. The cells are formatted.



Not a subscriber?

Start A Free Trial

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint