Training: Understand data at a glance with conditional formatting

Understand data at a glance with conditional formatting

Conditional formatting can highlight cells based on criteria, or "conditions," that you specify, making it easier to analyze data and identify patterns and trends. Download this series of videos to learn how.

Download

Inside this course:

Apply conditional formatting to numerical data (2:34)
Apply any of Excel’s 40 different conditional formats to help highlight trends in your data.

Apply conditional formatting to text (1:42)
Call attention to specific numerical data, or specific text by using conditions

Create a custom conditional formatting rule (1:53)
Create your own rules for conditional formatting

Practice file

Download and use this practice file for hands-on experience while watching the video.

ConditionalFormatting.xlsx (25 K)

More courses available at Microsoft Office Training.

Applies To: Excel for Mac 2011



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language