Need formula or VBA to lock cells based on value in other cells

[Dee]

Hi Guys,


Basically i am trying to calculate the volume and the input for this is in 4 columns ie.,input for length(L),width(W),depth(D) & diameter(Dia).

Requiremetn is,

If input for "L","W" & "D" is given then it should not allow user to enter value in "Dia" cell.

Similarly if input is given in "L" & "Di" then "W","D" should be locked from editing.


Thanking you in advance,

Dee

 

[xld]

Use data validation with a type of custom and a formula such as


=OR(A2="",B2="",C2="")

 

[ram]

kindly elaborate the type of custom

 

[Luke M]

Data Validation, custom, then input something like xld's formula.


E.g., validation for Dia is:

=OR(L="",W="",D="")


validation for W:

=OR(L="",Dia="")


etc.

 

[raef.qawasmi]