Is that possible? In cell B5 I put the number 1, then in B6 I put =B5 1 so that it reads 2, then I want that formula to go down until the end of the report which results in a row of blue cells. However, our reports always have a different number of lines.
Basically, the report runs out with a total line at the bottom, which is filled with dark blue. I want to, in column B, count how many rows until we hit that blue cell. There is no value or text in the blue cell though.