Conditional formatting provides visual cues to help you quickly make sense of your data. For example, it’ll clearly show highs and lows, or other data trends based on criteria you provide.
Other videos in this course
This video is part of a training course called Use conditional formatting. You can download the entire course or watch the videos online:
- Video: Use conditional formatting. (You are here!) Conditional formatting provides visual cues to help you quickly make sense of your data. For example, it’ll clearly show highs and lows, or other data trends based on criteria you provide.
- Video: Conditionally format dates. Say you want to see, at a glance, what tasks in a list are late. In other words, those tasks with due date dates before today. Or which tasks aren’t due for a week or more. Watch this video to learn how.
- Video: Conditionally format text. Use the Quick Analysis tool to conditionally format cells in a range that have duplicate text, unique text, and text that’s the same as text you specify. You can even conditionally format a row based on the text in one of the cells in the row.
- Video: Copy and remove conditional formatting. This video shows you how to quickly copy a cell’s formatting, remove conditional formatting from specific cells, and remove all conditional formatting from an entire worksheet.
Need a reminder of what you learned? See the course summary.
Ready for another tutorial? See the complete list of Excel 2013 training courses.