not allow blank cells

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.
 
C

CLR

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top