Hello Everyone,

I am trying to create a worksheet with greyed out/disabled rows based on a value.

A1 will have a unique number and B1 to G1 will have data related to this unique number.
The number of rows with data keeps changing. It can be from A1 to A5 or A1 to A100 .
I want to restrict the user from changing the values in B1 to G1 if A1 has a value in it.
So, IF A1<> ’blank’ then,B1 to G1 =”greyed out” and “disabled”. The already existing values in B1 to G1 should remain same.
The check will have to be performed until the last non blank cell in column A.

Please could the experts help me if there exists a possible solution.

Cheers!