Require answer dependant upon earlier cell information

[tomeck]

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.

 

[Bernard Liengme]

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