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. Watch this series of videos to learn how.
Learning Objectives
After completing this video, you'll be able to:
Apply conditional formatting to both numerical data and text.
Clear conditional formatting from formatted cells.
Create a custom conditional formatting rule.
Requirements
Excel for Mac 2011
Basic Excel
skills, including how to open a workbook, and select cells, columns, and rows.