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 ...

If your subtotaling rows are lost in a sea of worksheet data, use this simple conditional formatting technique to make those rows easy to spot.

Avoid frustration and unintended formatting by learning how Excel applies conditional formatting rules.