Conditional formatting with interval in specific range

Hello everyone,

Let me describe what I want to achieve...
Let's Assume I have three numbers, they are variables Start, Stop and Interval
Start B1=100
Stop B2=220
Interval B3=10

Now I want to create Formula which will create values dependent on Interval as it's showed attachment
I know I could just set A5=B1, B5=A5+$B$3, next A6=B5, B6=A6+$B$3 and repeat it in all rows, but...
As I wrote - Start, Stop and Interval are variables. Changing their values will give me different numbers of rows with values
For example, if I change Interval to 20 it would remove half of rows.

excel_1.jpg excel_2.jpg

How to setup Dynamic Range witch automatically add/remove rows?

Great thanks in advance!

Daniel

Many members are unable to see images in the *.png format due to forum compatibility issues with some browsers.

If you need to post an image post it in the *.jpg format.

Even better than posting images... post a SMALL sample file. That way we can test solutions directly in the file with the relevant data.

Normally, I don't work on issues where I have to set up a workbook, however this book was easy to set up.

Suc won't allow code/ formula today

forum formula.jpg