When you think VBA code is your only hope, try combing built-it conditional formatting tools. You might just find an easier solution than writing code. Editor’s Note: This article was originally ...

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. The article How to easily ...