Before you can set the conditional format, remove the subtotaling rows by clicking Subtotal (Data tab) and clicking Remove All. Assuming you want the entire row formatted, select the data set, B3 ...

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.

To get the exact format you want in Excel, it's often necessary to adjust the row heights to a specific size. By default, Excel rows are 12.75 points high, which is the typographical equivalent ...