Column must be filled before going another column.

K

kyoshirou

Hi..
Can i know how should i go with; in a way that users have to enter data for
column1 first before go to other column2. If user forget to enter for
column1, it will prompt the users.


thanks~
 
G

Gord Dibben

Data Validation is triggered by an incorrect entry, not by no entry at all so
this method cannot possibly work for user.

Rating.......low


Gord Dibben MS Excel MVP
 
G

Gord Dibben

From a Dave Peterson posting..............

I'd use a nice visible cell and format it in big bold red letters.

Say your range you want to check is 3 cells (a1:A3).

Then in B1:
=if(counta(a1:a3)=3,"","You must enter all three cells")

Actually, I like to use an adjacent cell for each cell that must be filled in.

=if(a1="","","<-- This cell cannot be left blank!")

End Dave P........................................


Gord Dibben MS Excel MVP
 
G

Gord Dibben

And Validation is under Data not Tools.

Lower yet.


Gord

Data Validation is triggered by an incorrect entry, not by no entry at all so
this method cannot possibly work for user.

Rating.......low


Gord Dibben MS Excel MVP
Click to expand...

Gord Dibben MS Excel MVP
 
Top