Microsoft Excel: Conditional Formatting for Understanding Data - AdvantEdge Training & Consulting

Microsoft Excel: Conditional Formatting for Understanding Data

Applying Conditional Formatting to your data allows you to identify variances in a range of data with a quick glance, by highlighting the differences or trends that you specify. You can customize the process by creating your own rules to apply to selected data. To apply conditional formatting:

    • Select the data range.
    • Click the Home Tab.
    • In the Styles Group, click Conditional Formatting.
    • Select New Rule.
    • The New Formatting Rule dialog box will open.


    • Select a Rule Type: In this section select the type of criteria you want to use to determine formatting. In my example I am using Format only cells that contain.
    • Edit the Rule Description: In this section determine which criteria to apply to the selected area. In my example I will be formatting based on the Cell Value applying the condition less than or equal to 150.
    • Click the Format.


    • The Format Cells dialog box appears. Select the formatting to be applied. In our example we will be changing the font color to red and making the text bold. You can also add a border or fill. Click OK twice.


    • Formatting will then be applied.


    • Repeat the process to apply additional formatting to a selected area.


For more ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting!

If you have at least 5 people we can create a session just for you.  Or, you can contact us for a private session. Contact Us

Questions? Don't see what you need?

We can help!

Business Training Classes
AdvantEdge Training & Consulting, Inc.

Recent Posts

Subscribe to our Newsletter

Copyright AdvantEdge Training & Consulting

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Scroll to Top