creating mandatory filelds

  • Thread starter Thread starter hilary
  • Start date Start date
H

hilary

there are some cells in my worksheet have to be filled if some field
are filled. i cant find how to give an error and return back thos
fields again to be fille
 
Hilary,

Any such solution can frustrate a user with error messages, unless carefully
thought out and implemented.

You can use a formula like this, which causes a message to appear in its
cell. The cell can be formatted for bold red.

=IF(AND(A2="", OR(B2<>"", C2<>"")),"Required information missing","")

Or for one formula that looks at several rows, entered as an array formula
(Ctrl-Shift-Enter). This one doesn't identify where the booboo is:

=IF(AND(A2:A5="", OR(B2:B5<>"", C2:C5<>"")),"Required information
missing","")

Or you can use conditional formatting to highlight the cell with missing
information. Post back for specifics.

The problem with these approaches is that these messages appear in some
cases before the user is finished entering the data, and this can frustrate
the user, and make him insensitive to error messages.

Another approach is a macro that issues a message when the user leaves the
row.
 
Back
Top