To make sure A1 is filled before A2

1. Select A2

2. Enter the below formula in DataValidationCustom and uncheck Ignore blank
=$A$1<""

3. Enter an error message say "Cells A1 should be entered firts" in Data
ValidationError Alert....and click OK.

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


"Link" wrote:

In a worksheet where you have to fill in information what formula to use if
you want to make sure (example cell A1 is filled in before A2) In other words
they if A1 is not filled in you cant move to A2.