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

[pansovic]

I created a formula that gives me a 0 (=0) in a cell and I want to create a Data Validation that gives me error message when somebody wants to delete the information to leave the cell blank. Can change the info in the cell as much you want but can never leave it empty.
I tried with =B2="" but doesn't work

[Marcol]

Try
Allow:= Custom

Please Login or Register  to view this content.

Uncheck the "Ignore blank" checkbox.

[pansovic]

Try
Allow:= Custom

Please Login or Register  to view this content.

Uncheck the "Ignore blank" checkbox.

No, this doesn't work

[Marcol]

Hmm? This is more difficult than I thought.
Whatever validation I tried it fails if the contents of the cell are deleted.
if a string of spaces is entered they are accepted.

It seems that VBa in the sheet module is the only sure way, perhaps someone else knows better.

See this workbook.

[Marcol]

There are serious errors on this Forum.

Attachments are extremely prone to failure and replies are not being recognised on the "Todays' Posts" page.

[pansovic]

Thanks but I am trying to avoid VBa because experience many troubles on other machines that are sharing the same file with me. On my PC all is fine but the others have all trouble. I don't know if it is realted that they are using Excel 2010 while I 2007 or is it related that VB are not compatible on network, I am not sure but prefer to avoid it.
Any help from somebody else will be more than welcome.
Thanks Marcol for the effort.

[dangelor]

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

=NOT(ISBLANK(B2))

and uncheck "Ignore blank"

[pansovic]

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

[Andy Pope]

Custom formula, =LEN($B$2)>0
Ignore Blanks unchecked.
Also ensure the Error Alert message is checked.

This will only work if the user edits the cell contents. If they simply delete or clear the cells contents no message will appear. That will require code.