Merged cells? Bingo! I don't work with merged cells myself, but the word is
they are the cause of untold problems. Since the formula I posted works for
me using no merged cells, and not for you with your merged cells, I'd have
to say that is what is causing the formula not to work.

Rick


"frustratedwthis" wrote in
message ...
I tried that, however, it gives me the validation error even if there is
text
in the cell. Another thing that might be causing the problem is, the
cells
are merged. (A12:I13)
I put the validation code in cells A17:20. I am not sure what it is I am
doing wrong
:(
Thanks


"Rick Rothstein (MVP - VB)" wrote:

You don't put the validation on the "description cell" itself, you put it
on
the cells below it that you don't want to allow an entry in if the
"description cell" is blank. For example, if B3 is the address of your
"description cell", then select the cells below it, starting with B4 (so
that B4 remains the active cell) and put this Custom formula in the
Data/Validation for that selection...

=LEN(OFFSET(B$4,-1,0))0

Just make sure you replace my example B$4 address with the address
(absolute
row) for the active cell in your selection.

Rick


"frustratedwthis" wrote in
message ...
I have read through MANY of the posts on here and haven't seemed to find
an
answer(and if I overlooked it, sorry!)
I am trying to put data validation on a "description" cell. I would
like
a
validation box to pop up if the user skips the description box and
fills
out
the information below it. Can this be done? I have tried ISBLANK, and
a
few
"" formulas and am having NO luck.
Thanks in advance :)