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.
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.
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 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 .
Similar to the tutorial above, this tutorial covers shading every other row of data in Excel using a formula and 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.
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.
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.
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.