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

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.

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