Force Cells to be completed based off another cell

Afternoon.

I am trying to use VBA to put measures onto a spreadsheet to no avail.

I am looking for some help with coding for the following.

Once D2 is completed I'm looking for each cell after up to J2 to be mandatory
If a cell is attempted to be completed not in sequence to remove the data and error to pop up
have this repeated for each row on the spreadsheet (700)
There will be some rows that only go up to C ( this seems to be where I am having the problem)

Any help would be great

Thanks

I've attached a sample of what the spreadsheet looks like fully completed.

The coding that I was using only looked from D on wards to J but was getting error messages when there was a row that didn't go past D.

So I am looking for the cells in the row for column E-J to be mandatory if there is a value in D.

So in theory if a value is inputted in D2 it forces them to input details into E2 and then F2 and so on until J2, and if they try to enter it in a cell that is not in order to remove this and show a pop up

There are a few options that they can input into column C - only if it is a yes will they need to fill in the remaining cells