 |
 | 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 / New Users / October 2007Data Validations contingent on each other
I have two data validation list cells - cell $D$15 (has the option of blank or "affiliate") and cell $E$72 (has the option of blank or 1% - 10%). When cell $D$15 is blank, there are no restrictions on cell $E$72. However, when cell $D$15 is "affiliate", I want cell $E$72 to default to blank & not allow any other options. How can I accomplish this? Thanks.  SignatureCathy Hi Cathy Take a look at Debra Dalgleish's site http://www.contextures.com/xlDataVal13.html SignatureRegards Roger Govier >I have two data validation list cells - cell $D$15 (has the option of blank > or "affiliate") and cell $E$72 (has the option of blank or 1% - 10%). [quoted text clipped - 4 lines] > not > allow any other options. How can I accomplish this? Thanks.
|
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.