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.

Fortunately, Excel enables users to instantly fill an entire row or selection of cells with the same formula with just a few keystrokes, with or without formatting.

How to use Excel’s Flash Fill feature, including a keyboard shortcut for both Windows and Excel for Mac.

Learn the many ways to insert entire and partial rows and columns in Excel, including a fill handle method.

Use Excel's conditional formatting feature to look at a specific cell in the row, determine if it's negative or positive and format the row based on the results.