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.


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.

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.