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 :)