count and highlight group of Consecutive cells according to cretiria

I'm sure there's a better way but if using the file from the original thread...

I'd first insert a blank row above the data (ie row 1 becomes row 2) and ensure row below last row of data to be analysed was also completely blank.

Assuming at that point the data values I'm interested in are in B2:B31 and number of interest was set in E6 and min group size was set in E5 then if you were to highlight B2:B31 you could apply a Conditional Format rule of:

Please Login or Register  to view this content.

Adjusting values in E5:E6 should affect the formatting of the data values accordingly.

As I say, I'm sure there are more elegant and more importantly more efficient approaches you could adopt.