[Walter Briscoe]

I have a questionnaire in a .doc which consists of a table:
A typical sequence of table rows is:

4.1 Were there toilets? Yes No goto 5.1
4.2 Were the toilets open? Yes No
4.3 Were the toilets clean? Yes No
5.1 Were there street lights? Yes No

I have a .xls data file which for our purposes can be considered to be
toilets
Yes

or
toilets
No

So, I start knowing the answer to 4.1.
If the answer is Yes, I want to highlight that answer in some fashion.
(With pen and paper, I would use a pen to circle the answer, bold would
satisfy my need when using printer and paper.)
If the answer is No, I want to highlight No and delete rows 4.2 and 4.3.

I could easily, if tediously, use if to empty those rows.
I want to make them vanish. So I would end up:

4.1 Were there toilets? No goto 5.1
5.1 Were there street lights? Yes No


Any suggestions as to how I might do this?
--
Walter Briscoe