Excel survey, skipping items

[JoshuaSQ]

Hi,

I am attempting to create an excel based survey that will skip/hide questions that are not applicable to the respondent. So, if question 7 is not applicable, it won't show 8 and 9, it instead skips to question 10.

I have been able to create this functionality, however, I have not been able to account for the possibility that someone changes their response. The way I currenlty have it set up, a changed response will make it so responses are not aligned with the correct item.

The biggest constraint is that I need to be able to do this without VBA. Is this possible?

I suppose in a worst case scenario I would just conditionally format the text so that the items appear to be missing. But any other ideas are welcomed.

Thanks in advance.

See attachment for current (but flawed) approach.

[DonkeyOte]

You won't be able to get prior selections reset based on retrospective alterations to precedents without the use of VBA I'm afraid.

[JoshuaSQ]

Thank you,

So at this point, do you think I am limited using conditional formatting to "gray out" the item, or an if statement to either disply or not display the item??

In the if-statement case I may have large blocks of white space. But I guess that would be acceptable.

Any other thoughts onl how I might approach this? (Again, without the use of VBA)

Thanks in advance.

Josh