Roulette data

Hi, I have a simple roulette simulator which generates 10,000 spins in excel using random generate between 0 and 36.
I have been trying to quantify some of the results, such as finding out throughout the 10,000 spins, how many times a black number or red number shows up 5 times in a row. And the same again for 6 times, 7 times and so on.

So basically i would like another part of the spreadsheet to read, for example:
No. of spins: 10,000
No. of times there were 5 of same colour in a row: 48
No. of times there were 6 of same colour in a row: 27
No. of times there were 7 of same colour in a row: 13
No. of times there were 8 of same colour in a row: 6
No. of times there were 9 of same colour in a row: 4
No. of times there were 10 of same colour in a row: 3

I was wondering if any of you may be able to help me figure out how to do this.
PS. i've attached the file, and just so you know reds and blacks are not assigned to even and odd numbers they are:
Red (1,3,5,7,9,12,14,16,18,19,21,23,25,27,30,32,34,36)
Black (2,4,6,8,10,11,13,15,17,20,22,24,26,28,29,31,33,35)

I would appreciate any help you could give me.

Stephen