1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Excel Conditional Formatting

Excel Condtional Formatting Tutorials

By

Excel's conditional formatting features let you control how a cell is formatted - such as changing colors - depending on the data the cell contains. If the cell data meets the conditions you set, then the formatting is applied to the cell. The tutorials in this list cover a number of options for using conditional formatting in Excel and include step by step examples.

Excel Conditional Formatting Options

Excel Conditional Formatting
Excel Conditional Formatting
Conditional formatting applies different formatting options when data in a cell or cells meets certain conditions. You choose the formatting that gets applied and you set the conditions that must be met. These conditions can include values equaling a certain amount, cells containing specific words, or data that is greater than or less than a specific value.

Creating Custom Conditional Formatting Rules in Excel

Excel Conditional Formatting
Excel Conditional Formatting
In addition to Excel's pre-set conditional formatting options, you can create custom rules using Excel formulas to test for user-specified conditions. This tutorial creates two custom rules to test for specific conditions in the data.

Find Duplicate Data in Excel with Conditional Formatting

Find Duplicate Data with Conditional Formatting
Excel Conditional Formatting
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 duplicates.

Excel Conditional Formatting a Date

Excel Conditional Formatting
Excel Conditional Formatting
Excel allows you to easily add conditional formatting so that a date that has past - such as overdue bills is easily spotted. The tutorial includes an example of using conditional formatting for dates in Excel .

Dynamically Shading Multiple Rows of Data with Conditional Formatting

Excel Conditional Formatting
Excel Conditional Formatting

Combining the MOD and ROW functions along with conditional formatting can be used to dynamically shade rows in a selected range of data.

Shading Alternate Rows with Conditional Formatting

Excel Conditional Formatting
Excel Conditional Formatting
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 with Conditional Formatting

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

Find Above or Below Average Data with Conditional Formatting

Excel Conditional Formatting
Excel Conditional Formatting
Two of the pre-set conditional formatting options that have been included since Excel 2007 are finding above and below average data in a selected range. This tutorial includes an example of how to find above average numbers.

Excel 2003 Conditional Formatting

Excel 2003 Conditional Formatting
Excel 2003 Conditional Formatting
Although the steps are a little different in previous versions of Excel, the purpose of conditional formatting remains the same. This article shows you the steps to apply conditional formatting that will work in Excel 97 to Excel 2003.

Excel 2003 Lists- Remove Duplicates with Conditional Formatting(video)

Excel 2003 Conditional Formatting
Excel 2003 Conditional Formatting
If you need a break from reading about conditional formatting, you can watch a video on the topic. This article walks you through using conditional formatting to remove duplicate data records in Excel 2003. But again, it applies to using conditional formatting in Excel 97 to Excel 2003.

©2014 About.com. All rights reserved.