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.
Find Duplicate Data in Excel 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 2007 to find duplicates.
Excel Conditional Formatting a Date
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 .
Shading Rows with Conditional Formatting in Excel
Excel Conditional Formatting
Conditional formatting can be used for shade alternate rows in a selected range of data. In large worksheets, shading alternate rows makes it easier to read data from left to right across the worksheet .
Find Above Average Values with Conditional Formatting
Excel Conditional Formatting
In Excel you can use conditional formatting to give you visual clues on what your data is doing statistically. One example is to use conditional formatting to highlight numbers that are above the average value in a list of data - such as above average costs, above average sales results, or above average results in an experiment. The article includes an example of using conditional formatting in Excel 2007 to highlight above average data values.
Find Below Average Values with Conditional Formatting
Excel Conditional Formatting
Similar to the tutorial above, conditional formatting can also be used to highlight numbers that are below the average value in a list of data - such as below average temperatures or rainfall, below average marks for students, or below average free throw percentage for basketball players. The article includes an example of using conditional formatting in Excel 2007 to highlight below average data values.
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
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.
