Skip navigation

On March 22 (PST) we will be performing site maintenance on the database to improve performance, which requires taking down the website for a short period of time. The work is being done between 9pm-12am PST (3 hours), but we will only have a maximum of 1 hour of down time. We do not know exactly when within the 3 hours window we will be down. Thank you for your patience and understanding.

Use conditional formatting

Use conditional formatting: Migrating from Office 2007 to Office 2016
Use conditional formatting: Migrating from Office 2007 to Office 2016

Conditional formatting of data in an Excel spreadsheet allows for varied formatting of your data based on certain conditions. It can be used to quickly pick out the top and bottom numbers, those number that are above or below a selected value, and more. In this movie, you will know how to use conditional formatting from he quick analysis tool to quickly format selected data based on default conditions set by the formatting option you choose.

Resume Transcript Auto-Scroll
Skill Level Beginner
1h 39m
Show More Show Less

Continue Assessment

You started this assessment previously and didn't complete it. You can pick up where you left off, or start over.

Start Your Free Trial Now

Start your free trial now, and begin learning software, business and creative skills—anytime, anywhere—with video instruction from recognized industry experts.

Start Your Free Trial Now