I think this is a feasible solution.

Your drop down should ideally be Data Validation on cells.
Then you use conditional formatting to make the additional 3 cell
appear when "Applicable" is selected and stay greyed out (defau
format) when "Not Applicable" is selected

--
jomn
-----------------------------------------------------------------------
jomni's Profile: http://www.excelforum.com/member.php...nfo&userid=774
View this thread: http://www.excelforum.com/showthread.php?threadid=52013