Counting records or values in Microsoft Excel is easy. Counting individual cells by their fill color definitely isn't. Using an old function and a matrix tames the problem.

We show you how to calculate percent change in Excel using a percentage change formula and some handy formatting tools. ... choose the red color, ... How to Use Alternating Rows in Excel.

Adding a running total to a simple Microsoft Excel revenue sheet isn't difficult, but adding a conditional running total will require a bit more effort. Solutions are simpler than you might think.