Show me how to use conditional formatting in Microsoft Excel 2007

Excel -> Microsoft Excel 2007

Problem: I want the formatting of a given cell to automatically change based upon its data.

Open Microsoft Excel 2007
Select a column
On the "Home" tab, under the "Styles" section, click the "Conditional Formatting" button
Click a formatting rule