i don't know anything about code and this is my first time with excel. I just want to find out how many cells are in between each conditionally formatted cell.
to change this:
row1: 4,4,1,2,1,5,4,3,2,1,4,3,2,4,1
row2: 5,2,1,5,3,1,5,1,3,4,2,1,4,2,2

to this:
row1: 4,4,1,2,1,5,4,3
row2: 2,1,4,3
row3: 2,4,1,5,2,1,5,3
row4: 1,5,1,3
row5: 4,2,1,4,2,2