This did work but then it occured to me that I could only have a section for
impacts or probabilitys relating to these and I need to have both coz I am
going to be linking it all up to seperate lookup tables dependent on their
outcome

"Debra Dalgleish" wrote:

You might be able to use dependent data validation, with the dependent
cells showing only an option of "N/A" unless a specific option is selected.

There's information he

http://www.contextures.com/xlDataVal02.html

Pasty wrote:
Is there a way of having it so if people select on option on a drop down list
it will only let them edit a certain drop down box later in the sheet? e.g.
If the select project risks the can only edit the drop down boxes relevant to
them and same for bottom up risks etc.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html