Hi,

I need to make a particular cell a required entry between 1 and 10. This cell must not be blank. I would have thought that this would be achieved by
  1. Setting the Data Validation to Allow="whole number", data="between", minimum="1", maximum="10"
  2. Clearing the checkbox "Ignore Blank"
Part 1 works fine, e.g. it gives an error if I enter "11"

However I can go to the cell, delete the contents and it doesn't give an error. My question therefore is what is the point of the "Ignore Blank" checkbox if point 2 doesn't prevent the cell from being left blank?

I've no problem achieving the desired result programmatically, so I'm not after an alternate solution, I'd just like to know whether this is a bug or whether this checkbox has a different use.

I've searched for similar posts regarding this checkbox but couldn't find a definite answer.

Thanks,
Vindaloo