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.

Adding color creates a great visual effect, but did you know that you can evaluate values by color? Use this technique to turn color into valuable information.

How to Fill a Formula Across Excel. Excel formulas are a powerful way to quickly manipulate and display the data in your spreadsheets to your exact specifications. Once you've created an effective ...