conditional data entry

[Mike]

Is it possible to prevent data entry in a cell until
entries in other cells, on the same worksheet, are input?

Or is it possible to hide data entered in a cell until
entries in other cells, on the same worksheet, are input?

Example: hide or prevent entry in A1 until entry in
B1,B2,B3 is complete.

 

[JMay]

With active Cell A1 goto Menu, Data Validation
Allow box: Custom
In formula box enter:

=AND(LEN(B1)>0,LEN(B2)>0,LEN(B3)>0)

HTH