Using The Excel Conditional Formatting

Excel conditional formatting allows you to apply different formatting options, such as color, to a cell or cells based on the data in the cell(s).

Here are the 2 easy steps to implement the conditional formatting:
1. Create a set of conditions that control formatting changes in the target cells.
2. Enter your data. If the conditions you set are met by the data, then the formatting is applied.
Note: Up to three conditions can be set for a cell, so it is possible to vary the formatting as the contents of a cell changes.

To format cells using conditional formatting

  • If we enter the data as illustrated, we can then apply conditional formatting to it.

  • Select the range of cells which you wish to apply conditional formatting. In this example the range would be A1:C5.
  • From the Format menu, click Conditional Formatting.

  • Lets say we wish to highlight all values between 4 and 6, then we would enter the numbers in the correct fields, as illustrated above.
  • If we click on the OK button, then no special formatting would be applied to these values, so next we need to click on the Format button within this dialog box.

    Format Cells dialog box

  • From the normal Format Cells dialog box is displayed, from which we can specify how data that meets the specified criteria will be displayed.
  • Select a color for the conditional formatting; choose red, for this example.
  • When finished click on the OK button to close this dialog box, which will return to the Conditional Formatting dialog box.
  • To add the other conditional formats, click the Add button. Otherwise, click on OK button to close this dialog box.

    Get FREE ebooks!
    (Click for more info)

    Subscribe to...
    MS Office Tips Newsletter

    E-mail Address:
    First Name:

    Don't worry -- your e-mail address is totally secure.
    I promise to use it only to send you MS Office Tips.

    Can't find what you're looking for? Try Google Search!


    Back to Top

    >> Next Topic : How to Install, Remove and Get Free Excel Add-in?

    << Previous Topic : Solve Your Excel Problem with Microsoft Office Assistant

    You're viewing the Excel Conditional Formatting info page, click here to go back to the Home Page