Enhancements to conditional formatting are a popular feature in Microsoft Office Excel 2007. Analyzing data has never been more interesting and colorful. Now, you can track trends, check status, spot data, and find top values like never before.

We've provided a workbook full of examples and guidelines to help you get up-to-speed. Here's a summary of what's in the workbook.

To download the workbook, do the following:

 Important   The following workbook requires Microsoft Office Excel 2007.

1. Click the link Conditional Formatting Samples.
2. In the File Download dialog box, click Save.

    Note   Do not click Open because doing so will display a warning message and open a read-only version of the workbook.

3. In the Save As dialog box, click Save.
4. When the file download is complete, click Open.

• Conditional Formatting - Thick Border?
• How can I use conditional formatting to hide or delete rows?
• How do I use conditional formatting for an entire column?
• Conditional formating to highlight dates 30, 60, and 90 days out?
• How to change a cell color based on its content using macro?
• Incorporating Cell color fill in an "if" logical function?
• In Excel, conditional format (font red) referencing another cell?