For the sake of this example, cell C2 is the cell I want to fill out, and depending on the value of A2, i may or may not want to use data validation lists.
If A2 is True, I want C2 to refer to a list, but if A2 is false, I want to make the cell open to any input. Is this possible? I've read through all of the tutorials on contextures and haven't found something quite like this.
The DV properties would allow you to make the LIST appear or disappear based on A2 being TRUE or not, but the ability to type anything into the cell, too, well that would either always be true, never be true using inbuilt functions. So even if A2 was false, if the DV settings were to allow free entry, they could do that at any time.
However, all is not lost. You could employ a Conditional Formatting trick at the same time in C2. Using Conditional Formatting, you could test the values of A2 and C2 and HIDE the value in C2 if A2=true and C2 does not match an option from the DV list.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thanks for the feedback.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks