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.

How to Auto-Format the Date in MS Excel. ... you share files with colleagues who enter data but don't know Excel well enough to set up files. ... column or row header to select all the cells that ...

JD Sartain. Use View > Split to split or unsplit a screen in Excel.. 2. Freeze Frames. The other great feature for large spreadsheets is Freeze Frames. People generally freeze frames so they can ...