Excel Conditional Formatting Tutorials

Conditional Formatting Data in Excel
This tutorial covers a number of Excel's preset conditional formatting options such as matching text, finding the current date, and finding values that equal a specific number.

Find Duplicates in Excel with Conditional Formatting
This tutorial shows you how find a variety of duplicate data - formulas, numbers, dates, data records - in Excel using conditional formatting. The tutorial includes an example of using conditional formatting in Excel to find duplicate data.

Excel Conditional Formatting for Dates
This tutorial shows you how apply conditional formatting to cells in Excel. The tutorial includes a step by step example of using conditional formatting in Excel.

Excel Conditional Formatting Date Formula
This tutorial uses date formulas to create custom conditional formatting rules to highlight past due dates.

Shading Multiple Rows of Data in Excel
This tutorial covers dynamically shading multiple rows of data in Excel using a formula and conditional formatting.

Excel Shading Alternate Rows Formula
Similar to the tutorial above, this tutorial covers shading every other row of data in Excel using a formula and conditional formatting.

Shading Columns of Data in Excel
Instead of shading rows, this tutorial uses a formula combining and conditional formatting to apply different patterns of shading to columns in a worksheet.

Finding Above and Below Average Data Values with Condtional Formatting
One of the preset conditions for conditional formatting since Excel 2007 is that above or below average data values can be formatted to stand out in a worksheet. A step by step example is included with the tutorial.

Excel 2003 Conditional Formatting
This tutorial covers how to use conditional formatting in Excel 2003 and earlier versions of the program.