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.

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!