How do I set specific cells for mandatory entry?
 

I want to set a group of cells which cannot be left blank in a worksheet. is
this possible?

How do I set specific cells for mandatory entry?
 

Possibly. What are your preventing? (what process would occur that you don't
want to happen if there are blanks)

One simple way is:
=COUNTBLANK(A2,B2,C3:C6)=0

Where you refer to all the cells you don't want blank. Formula returns a
boolean, which can be used in various ways to stop/halt/notify people.

You might also look into using the formula in Data-Validation.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"vanarsdalet" wrote:

I want to set a group of cells which cannot be left blank in a worksheet. is
this possible?

How do I set specific cells for mandatory entry?
 

I'm not sure this is what you have in mind but it is worse to checkout:
* Suppose you have some header in cell A1.
* Select the range A3:A50 click Data Data Validation choose "Custom"
in the "Formula" box type:
=COUNTA($A$2:$A2)=ROW()-2
* Watch the Absolute/Relative Addresses *
Micky


"vanarsdalet" wrote:

I want to set a group of cells which cannot be left blank in a worksheet. is
this possible?

How do I set specific cells for mandatory entry?
 

OR:
* Select the Range A2:A50.
* Data Data Validation choose "Custom" in the "Formula" box type:
=NOT(ISBLANK(A1))
* UnCheck the "IGNORE BLANK" Checkbox.
Micky


"מיכאל (מיקי) אבידן" wrote:

I'm not sure this is what you have in mind but it is worse to checkout:
* Suppose you have some header in cell A1.
* Select the range A3:A50 click Data Data Validation choose "Custom"
in the "Formula" box type:
=COUNTA($A$2:$A2)=ROW()-2
* Watch the Absolute/Relative Addresses *
Micky


"vanarsdalet" wrote:

I want to set a group of cells which cannot be left blank in a worksheet. is
this possible?