not allow blank cells

I am looking for some sort of data validation to not allow a blank cell
within a range. Every cell must have a value. Also, the values must be
between 0 and 60. I have tried Data, Validation, uncking the Ignore blanks
box, but it stioll allows me to cancel the validation error and use a blank
cell.
--
Thank you,
Maggie

One thing you can do is to "conditionalize" your next step..........for
instance if you were going to sum the range A1:A10 and wanted to be sure
there was a value in every cell in that range, then for your sum formula you
could use

=IF(COUNT(A1:A10)=10, SUM(A1:A10),"Enter all values")

and use standard Validation to make sure the values are between 0 and
60..........

Vaya con Dios,
Chuck, CABGx3



"Maggie" <[email protected]> wrote in message
news:[email protected]...
> I am looking for some sort of data validation to not allow a blank cell
> within a range. Every cell must have a value. Also, the values must be
> between 0 and 60. I have tried Data, Validation, uncking the Ignore blanks
> box, but it stioll allows me to cancel the validation error and use a
blank
> cell.
> --
> Thank you,
> Maggie