Counting Colors Conditionally
There is an Excel file that teaches how to perform the Counting Colors Conditionally operation.
Excel Spreadsheet for Counting Colors Conditionally
This workbook demonstrates counting colors conditionally using VBA macros on a 5-row data layout.
Hope it is useful.