Figure E Subtotal adds a function to the subtotaling row. Before you can set the conditional format, remove the subtotaling rows by clicking Subtotal (Data tab) and clicking Remove All.

Microsoft Excel 2007's conditional formatting feature allows you to format cells based on certain criteria. As an example, you might want the row color to change based upon a credit or debit on a ...

Learn how to use Excel's Format Painter to apply formatting to entire rows and columns. Formatting allows viewers to distinguish values by type and even sections.

Type the name of the new column in row 3 and notice that Excel adds the filtering and style format automatically. 11. It’s also easy to add new records.