I am using Excel 2007 for a survey. In one cell, i have a list of items they
can select with the last item being "Other." This cell uses data validation
to limit the input to the list.

After this question, i have another cell that is to be filled in if they
selected other in the prior question. I would like to require that they fill
in this cell if they do check "Other."

Is there a simple way to validate that the second cell is not blank if other
is selected in the first cell?

Thanks.

That would be hard to do but here is a compromise: use Conditional
Formatting such that if first cell is "Other" then the next cell goes red if
it is blank
On the Conditional Formatting dialog use =AND(E15="Other",ISBLANK(F15))
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"tomeck" wrote in message
...
I am using Excel 2007 for a survey. In one cell, i have a list of items
they
can select with the last item being "Other." This cell uses data
validation
to limit the input to the list.

After this question, i have another cell that is to be filled in if they
selected other in the prior question. I would like to require that they
fill
in this cell if they do check "Other."

Is there a simple way to validate that the second cell is not blank if
other
is selected in the first cell?

Thanks.