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

Part 4. Formatting Worksheet Data > Using Conditional Formatting

Using Conditional Formatting

Select the cells to which you want to apply conditional formatting, then open the Format menu and choose Conditional Formatting.

In the conditional Formatting dialog box, keep Condition as the default Cell Value Is; the other option, Formula Is, is for indicating a specific formula.

Display the second drop-down list to select the type of condition (for example, greater than).

Type the value of the condition (the number that the cells must be “greater than”).


There might be times when you want the formatting of a cell to depend on the value it contains. For this, use conditional formatting, which lets you specify conditions that, when met, cause the cell to be formatted in the manner defined for that condition. If none of the conditions are met, the cell keeps its original formatting. For example, you can set a conditional format such that if sales for a particular month were above $4,000, the data in the cell is bold and red.


Painting a format onto other cells

You can copy the conditional formatting from one cell to another. To do so, click the cell whose formatting you want to copy. Then click the Format Painter button. Finally, drag over the cells to which you want to copy the formatting.

Click the Format button to set the format to use when the condition is met.

Click the options you want to set in the Format Cells dialog box (for example, Pink in the Color field and Bold in the Font style list), and click OK.

Click OK in the Conditional Formatting dialog box.

Excel applies the formatting to any cells that meet the condition you specified.



Not a subscriber?

Start A Free Trial

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