Required Entry

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

I am creating a spreadsheet and I need to ensure data
entry is required in a column when data has been enterd
into a previous column. Any help on this would be much
appreciated. Thanks.
 
I would use an additional column.

Say B3 has to have something in it when A3 has data in it.

In C3:

=IF(A3="","",IF(B3<>"","","Please enter something in B3"))
Format it in nice big bold red letters.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Average cells based on column header 6
VBA - retrieve data on last create named range from previous inserted named range 0
Auto concantenate 1
Multiple entries query 6
requiring column entries 1
Validation based on output of a different cell. 4
Migrate mailboxes from one Microsoft Exchange Server to another Exchange 1

Back
Top