Conditional formatting

[12 minutes total]

Imagine being able to quickly color code all of the data in one or more columns to highlight patterns and trends in your data file. That's what the Conditional formatting feature does and why it's one of the most useful Excel skills educators can possess (it's especially useful when combined with Excel's Filter feature). These five tutorials show how to use this powerful tool.

After viewing the tutorial(s), use the back key in your browser to return to this web site.

• Changing a numerical cell's color with single conditional formatting conditions (2:17)
• Changing a numerical cell's color with multiple conditional formatting conditions (1:50)
• Changing a text cell's color with single conditional formatting conditions (0:55)
• Changing a text cell's color with multiple conditional formatting conditions (2:53)
• Changing a cell's color with calculated value conditions (3:58)

You may need to turn off your browser's pop-up blocker or install the latest Flash plug-in to view these tutorials.