Page 1 of 8PREVNEXT

Understand data at a glance with conditional formatting

Judi Hurlock
Sometimes it’s hard to read and interpret data by scanning rows and rows of information. But you can use conditional formatting to make certain data stand out, helping you to analyze data, and to identify patterns and trends.
By Judi Hurlock, Senior Writer

About this course

This course includes:

  • One self-paced lesson
  • One practice session for hands-on experience. The practice requires Excel 2010.
  • A short test at the end of the lesson. The test is not scored.
  • A Quick Reference Card you can print at the end of the course.


After completing this course you will be able to:

  • Make data stand out by applying conditional formatting to cells.
  • Decide which type of conditional formatting to apply.
  • Clear conditional formatting from cells.
  • Make your own conditional formatting rules.

See more courses on Microsoft Office Training.

Page 1 of 8PREVNEXT