 |
 | 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 / Worksheet Functions / October 2007Conditional Data Validation
Hi! I am trying to enforce selection from a list (Range1) in column D when the value in column c is equal to "Hello", if the value in column c does not equal "Hello" I want the user to be able to type in whatever they want in column D. I have pored through the newsgroup and not found anything relevant, hence this question...Thanks... Make sure that the C cell has the value Hello in it, then add this formula to the DV type of List =IF(C1="Hello",rng) where rng is the range of your list  SignatureHTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) > Hi! I am trying to enforce selection from a list (Range1) in column D when > the value in column c is equal to "Hello", if the value in column c does [quoted text clipped - 3 lines] > relevant, > hence this question...Thanks... Bob, thank you for your prompt response. I have already gotten that far. The problem is when column C does not equal "Hello" I want the user to be able to enter whatever they want in column D and validation seems to be enforcing "" > Make sure that the C cell has the value Hello in it, then add this formula > to the DV type of List [quoted text clipped - 10 lines] > > relevant, > > hence this question...Thanks... You have to follow Bob's directions, it does what you want. SignatureRegards, Peo Sjoblom > Bob, thank you for your prompt response. I have already gotten that far. > The [quoted text clipped - 21 lines] >> > relevant, >> > hence this question...Thanks... It works if the next row of column C is blank as it will then allow you to type text in freeform in column D. However, if there is any string in that cell of column c the validation will disallow any other entry in column D. My column C will always have text values in it and occasionally they will contain "Hello" but more often than not they will not. I appreciate your help nonetheless. Thanks. > You have to follow Bob's directions, it does what you want. > [quoted text clipped - 23 lines] > >> > relevant, > >> > hence this question...Thanks... You are right, the reason it works is because it ignores blanks unless it is unchecked. AFAIK you cannot fix this since you would be using conditions which are opposite to each other The condition to display the list is that C1 equals "Hello", then you cannot also have a condition that says something else. Meaning that validation block entries that return FALSE so if C1 is not "Hello" but has some sort of entry the formula returns FALSE thus blocking any other entry SignatureRegards, Peo Sjoblom > It works if the next row of column C is blank as it will then allow you to > type text in freeform in column D. However, if there is any string in that [quoted text clipped - 37 lines] >> >> > relevant, >> >> > hence this question...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.