How to count the number of highlighted (colored) cells in each row?
And bonus question: How to count the number of consecutive colored cells in a row (e.g. A8 and B8 would be 1, A8 and B8, and D8 and E8 would be 2)?
And bonus question: How to count the number of consecutive colored cells in a row (e.g. A8 and B8 would be 1, A8 and B8, and D8 and E8 would be 2)?