Require answer dependant upon earlier cell information
 

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.

Require answer dependant upon earlier cell information
 

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.