If you want an entry to be restricted in B5 until B1 is filled using
***formulas ****

1. Select B5 and from menu DatavalidationSettings tab Select 'Custom'

Enter formula:
=B1<""

2. Uncheck 'Ignore blank'

If this post helps click Yes
---------------
Jacob Skaria


"Link" wrote:

I have a work book that people need to fill in information; I want to make
sure certain cell are filled in before they can proceed to the other. ( eg.
Cell B1 before B5 then D5 ......) is there a formula function that can be
used for this?