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?