Excel Cool Tool: Conditional Formatting

by | May 4, 2015

Conditional Formatting allows you to automatically apply miniature graphs, colors, and icons based on cell contents, so you can quickly compare your data. It’s an extremely helpful tool for small businesses.

Conditional Formatting in Use

For example, if your company has a limited overtime policy, you can set cells with values over 40 hours to show as red and immediately see which employees regularly clock overtime.

Want to know which of your products are your best sellers? Use Conditional Formatting to show your hottest sellers in red to your poorest performers in blue.

DarkHorse Analytics used Microsoft Excel and Conditional Formatting to create a 24-hour breathing map of the population of Manhattan at work and at home. So cool! See it here.

Watch our video below for a quick tutorial on Conditional Formatting with Data Bars.

If you want to learn more, take my Learn Excel in 3 Hours Flat online course on Udemy.com. You’ll not only learn all the practical tools you’ll use on the job everyday, but also how to be more productive!

Act now and get the course for only $59 $49.

Take this Course

Related Posts

[related_posts limit=”4″ image=”150″]

About Alicia Katz Pollock

With a Masters in Teaching from Tufts University, a QuickBooks®️ Online Advanced Certification and more than 30 years’ experience in the tech industry, Alicia is passionate about finding creative, practical solutions to complex and everyday tech problems. She also loves a good laugh!

Comments

0 Comments

Submit a Comment

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