Filling A Number Of Cells Based On Numerical Value

[Ryan_Bernal]

Hello guys,
Good day!
Need help regarding on this.
I just want to filling A Number Of Cells Based On Numerical Value.
So that it will tell the user to input only on the filled cells.
Let say B3 is the numerical value and the cells to be filled is from range E3:N10
The value of B3=5 then the cells should be fill are range E3:I5.
When there is data that will be inputted after I5 the cell will filled with red color.
Here is my workbook.
Thanks in advance.

[Ryan_Bernal]

I already solve my own problem. using conditional formatting.
But if you have better solutions, please let me know.
Thank you so much.

[Admin]

Thanks for sharing :)

[Ryan_Bernal]

Thanks for sharing :)

I am much thankful to become a member of this forum. Excelfox.com ROCKS!!! \íi/;)

[Kevin@Radstock]

Hi Ryan_Bernal

Another solution for the formatting might be.
Rule 1 Green: =COLUMNS($E$3:E3)<=$B$3
Rule 2 Red: =AND(E$3<>"",COLUMNS($E$3:E3)>$B$3)

Kevin

[Ryan_Bernal]

Hi Ryan_Bernal

Another solution for the formatting might be.
Rule 1 Green: =COLUMNS($E$3:E3)<=$B$3
Rule 2 Red: =AND(E$3<>"",COLUMNS($E$3:E3)>$B$3)

Kevin

Thanks bro.

https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA (https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA)