 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / March 2006Drop-down leading to more Cells
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.  Signaturebengaluru Any help here please ??? Signaturebengaluru bengaluru Wrote: > Any help here please ??? Is there no one who can help me ? Is your drop-down generated by Data>Validation>List ? Or is it a combobox? -- AP > bengaluru Wrote: > > Any help here please ??? > > Is there no one who can help me ?? 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 Yes. My drop-down menu is generated by Data>Validation>List. Thank |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.