This example shows you how to use conditional formatting to shade alternate rows.

To create a heat map in Excel, simply use conditional formatting.

Icon Sets in Excel make it very easy to visualize values in a range of cells.

This example teaches you how to find and highlight duplicates (or triplicates) in Excel.

To view all conditional formatting rules in a workbook, use the Conditional Formatting Rules Manager.

This example teaches you how to create a checklist in Excel.

Color Scales in Excel make it very easy to visualize values in a range of cells.

This example describes how to compare two lists using conditional formatting.

Sometimes multiple conditional formatting rules in Excel conflict.

Data bars in Excel make it very easy to visualize values in a range of cells.