Hi,

i have a column of cells D5:D369 to be exact of which i need to coun
the amount of times red coloured cells are followed by white coloure
cells and to output a 1 and then for that to be incremented each time
red cell is followed by a white one in the range.

If anyone could provide code that would be amazing as i have no ide
how to do it myself!

Thank

--
alymcmorlan
-----------------------------------------------------------------------
alymcmorland's Profile: http://www.excelforum.com/member.php...fo&userid=2765
View this thread: http://www.excelforum.com/showthread.php?threadid=47178