Hi Guys,
I have a spreadsheet that has the columns conditionally formatted depending on cell value. I was wondering if it's possible to count the maximum consecutive cells across rows. I've attached a small sample. The result I want is maximum number of consecutive blue fonts in the whole spreadsheet which in this case is 4. Many thanks in advance.
Mop.