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

Part 11. 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 select Conditional Formatting.

In the Conditional Formatting dialog box, keep the default Condition 1 as Cell Value Is (use Formula Is to indicate 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”).


You might want the formatting of a cell to depend on the value it contains. For this, you 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 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, Purple 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