Hi Dave,
Yes, this can be done with VBA, but the important point is that Excel’s normal COUNTIF/COUNTIFS functions don’t directly count cells based on their fill color.
If the colors are applied manually, a small VBA user-defined function is probably the simplest approach. Another option is to...
