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.

Learn how to sum and count Excel cells by color with 3 easy methods. Save time, reduce errors, and boost your data analysis skills today ...

Want to to alternate row colors in Excel? You can apply color in alternate row & column in Excel spreadsheet using Conditional Formatting.

How to Make Excel Continue to Count Up for Each Row. Entering a series of sequential numbers into an Excel spreadsheet, one per row, can be a time-consuming and repetitive task.

How to Make Colors Change With Validation in Excel. Excel's conditional formatting tool applies formatting depending on cells' contents. Validation rules can change cells font, style, size or border.

I have a set of spreadsheets where the data (text) is color-coded by row. Would it be feasible to write a formula or script to count how many of what color rows are spread across the workbooks in ...

When counting unique values in Microsoft Excel, use UNIQUE() as a helper function and avoid more complicated expressions.