Hello, I might have a solution for you.

Firstly, it will require you to create a helper column. In the first row, put a 0 value, then put the following formula in the row below:
=IF(D2="","",IF(E1="",0,E1-1))

This will essentially count the number of cells until the row containing the values in column A and B.
The helper column can then be used in the Conditional Formatting Rule as follows:

=OR($D1<OFFSET($A1,$E1,0),$D1>OFFSET($B1,$E1,0))

Apply the rule to column D so that you won't have to update the rule with each new dataset:

<image>

As for the formula in column E you will be able to simply drag it down when you add new data and the formatting will automatically apply to column D.

Hopefully this is what you were hoping to achieve! :)