I'm a complete newb to VBA but I am trying to make a spreadsheet that looks like this:

Column A is numbered 1-175 and each numbered row has 8 cells from column B to I that will hold number data.
The number data in each cell will range 0.1865-0.1885, if the data entered is out of the range it gets highlighted yellow.

What I want the spreadsheet to be able to do is if there is an out of range data value entered into a row I want it to create a new row with the same number in column A as the previous row and an * next to the number. This should only be able to happen twice for each row so the second time an out of range value is entered the same number in column A is made on a new line with ** next to it. I apologize if I am not being clear enough.

for example/clarification:
A B C D E F G H I
1 x x x x x x x x <---Out of range value so another "1*" line created
1* x x x x x x x x <---A Second Out of Range entry so one more line created with "1**"
1**x x x x x x x x <---Even though this last line has an out of range value it has reached its maximum number of attempts and will not create another line with the number "1"
2

Can anyone help me to write some code for this? Thanks in advance!