Excel: Differentiate data at a glance - AdvantEdge Training & Consulting

Excel: Differentiate data at a glance

Microsoft Excel 2013 introduced a new feature that lets you differentiate data at a glance: Conditional formatting. This handy tool will apply colors to a cell’s font and background depending on the conditions you’ve set – for instance, if you want to highlight any cell that features a specific name or date, or differentiate high, medium and low numerical values. Follow these directions to set up your own conditional formatting in a few simple steps.
1. Select the cells you want to format.
Excel Conditional formatting
2. From the Home menu tab, select Conditional Formatting on the Ribbon, Highlight Cells Rules and Greater Than
Excel Conditional formatting
3. In the Greater Than box, type your threshold amount that you want the cell amounts to be reflected by the color in the “with” box. In the example below, we want any amount greater than 5000.00 to have a green background with green text.
Excel Conditional formatting

For more ways to wrangle your data, take an Excel training course from AETC.

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