Excel 2007 : Date validation to give error when nothing is filled in

Originally Posted by dangelor

Try Data>Data Validation>Allow:Custom>Formula:

=NOT(ISBLANK(B2))

and uncheck "Ignore blank"

Neither this is working. I tried with check "Ignore blank" without but nothing is doing it. The formula I have tranlated in spanish as =NO(ESBLANCO(B2)) according to the site http://drop.by/excel-translator.php