Drop-down leading to more Cells

[bengaluru]

Hello everyone,

I know this is possible but do not know how to make it.

I have two options in a Cell as Applicable and Not Applicable. This is in a Drop-down menu and what I want is that when I choose Applicable, it should bring up additional 5 or 6 cells for me to complete. And if I choose Not Applicable, the additional cells should not show up. The default would be Not Applicable.

Can somebody help please. Thanks in adance.

[bengaluru]

Any help here please ???

[bengaluru]

Any help here please ???

Is there no one who can help me ??

[Ardus Petus]

Is your drop-down generated by Data>Validation>List ?
Or is it a combobox?

--
AP

"bengaluru" <[email protected]> a écrit
dans le message de
news:[email protected]...
>
> bengaluru Wrote:
> > Any help here please ???
>
> Is there no one who can help me ??
>
>
> --
> bengaluru
> ------------------------------------------------------------------------
> bengaluru's Profile:
http://www.excelforum.com/member.php...o&userid=24188
> View this thread: http://www.excelforum.com/showthread...hreadid=520139
>

[jomni]

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 cells appear when "Applicable" is selected and stay greyed out (defaul format) when "Not Applicable" is selected.

[bengaluru]

Yes. My drop-down menu is generated by Data>Validation>List.

Thanks