not allow blank cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top