Count Consecutive Colored Cell Ranges

You could use a VBA UDF - copy the code below into a standard codemodule, save your workbook as a .xlsm file, and use the UDF like this

=CCBlocks($A2:$N2,O$1)

and copy it to match your color ranges. Note that it will not auto-recalc since format color changes do not force a re-calc automatically.

Also, this is written to work with standard formatting, not conditional formatting.

Please Login or Register  to view this content.