Popup messages when different scenarios are selected

[Justine]

Hi

I am trying to figure out a way for a message to pop up
when a certain scenario has been selected to show the
person what series of steps to take next. There are a
group of questions that have a selection of different
answers, the cell with the answers are validated with the
list function for the user to choose and depending on what
has been chosen there are different steps, i.e. If yes is
selected then questions 4-6 need to be answered but if no
is selected then questions 2,3 & 7 need to be answered. Is
there any way a message either on a dialog box or cell
that can pop with the next step message?

Really appreciate your help

Cheers

Justine

 

[Brad E]

Justine, I have done something similar. In an empty
cell, you could use a formula of this sort:
=IF(Answer = "YES", "Please complete questions 4-6.", IF
(Answer = "NO", "Please complete questions 2, 3, & 7.",""))

Brad E.