one_more_cave_dweller
Board Regular
- Joined
- Sep 27, 2004
- Messages
- 118
I would like to require the user to enter a number into a2 before they can enter a number in a1. How can I do this
Thanks ray:
Thanks ray:
vconfused said:Data->Validation is used to make sure you enter appropriate values, but it cannot be used to allow/disallow you from entering values.
ken2step said:Also....
=ISNUMBER(A2) Uncheck the box "ignore blank"
works as well