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.

 

[Doug Robbins - Word MVP on news.microsoft.com]

I would suggest that you ask your question in the
microsoft.public.excel.programming newsgroup. This one is for Word.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

 

[tomeck]

Thanks - I will do that. My mistake to post here.