Use Conditional Formatting to Highlight - AdvantEdge Training & Consulting

Use Conditional Formatting to Highlight

Instead of scanning all of the information in a spreadsheet, use conditional formatting to highlight when issues exist. Then all you will need to do is look for colorful indicators.
Example:
conditional formatting excel
The conditional formatting formula, in this case, is:
conditional formatting excel
Conditional formatting is a great way to reduce the time spent on tedious tasks.

Find other ways to save time (and maybe your eyesight!): Take an Excel training class 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