conditional data entry

  • Thread starter Thread starter Mike
  • Start date Start date
M

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.
 
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
 
Back
Top