The following will walk through each menu item. The Condition Formatting menu contains 5 primary styles, and 3 other options. This improvement provides opportunities for more dynamic spreadsheets that can respond to various changes made by the user. Prior to 2007, you would only be able to change the fill color of cell A1. For example, you could create a conditional format to test if cell A1 was equal to 1, which if true, would change the fill color of cell D2 green. The most valuable improvement, however, is the ability to apply conditional formatting to cells outside of the test range. These improvements included the addition of icons, gradients, and more complex test options. The 2007 version of excel implemented many improvements to the feature. Note that there are some backwards compatibility issues with conditional formatting.
