Conditional Formatting in MS Excel

Conditional Formatting in MS Excel

Conditional formatting is a very useful tool that will allow you to automatically format your data in order to provide a useful way to visualize information and make your worksheet easier to understand. With conditional formatting, you will be able to apply formatting such as different colors to one or more cells based on cell value. The following explains how to apply Conditional Formatting to your spreadsheet.

  1. Select the desired cell range that you wish to apply the conditional formatting rule.

    2. From the Home tab, click Conditional Formatting.

    3. In the drop-down menu, hover your mouse over Highlight Cell Rules to display conditional formatting types
    4. In this example, we want to highlight those values greater than $5000. To do so, click the Greater Than option.

  2. In the Greater Than box that appears, enter the desired value into the field. In this example, enter 5000

    6. In the formatting style drop-down, select your preferred highlight colors.

    7. The conditional formatting style will be applied to the selected cells.

    To Clear Conditional Formatting in MS Excel

    The following explains how to remove conditional formatting from your entire spreadsheet:

    1. From the Home tab, click Conditional Formatting.
    2. A drop-down box appears. Hover your mouse over Clear Rules to view a list of options for removal of rules
       3. To clear rules from the entire sheet, click Clear Rules from Entire Sheet. Your Conditional Formatting rules will be cleared.

     

Leave a Reply

Your email address will not be published. Required fields are marked *