Training: 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
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.