Hi,
I have two columns with following Data Validation Settings;
Column A is named "BID" and allowed data entries are from list "YES" or "NO"
Column B is named "STATUS" where I have allowed data entries of "WON", "PENDING", "LOST"
I want the Column B entry be available only if Column A entry is "YES" that is Column B should be locked when Column A data says "NO".
How can this be done?
Thank you,
You could use Dependent Data Validations with nothing in the "No" List. I have attached an example. You could have the named lists on another sheet if you like. Here's a link that explains Dependent D.V.
http://www.contextures.com/xlDataVal02.html
Does this work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Hi,
One option would be to put the following formula in the Data Validation List option
where D1:D3 contains your 'Won, Pending or Lost' labels.
Please Login or Register to view this content.
HTH
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thank you for your answers, they were really helpful!
I have one more additional question. In your resolutions, if user FIRST chooses "YES" in "bid" Column he can choose "Won" "Lost" "Pending" in "status" column. But is it able to link the contents of the cells reciprocally so that if a user after entering "YES" and "Won" changes the bid column to be "NO" the "status" column would automatically clear its contents?
Thank you,
That requires some code. Right click on the tab and paste this code in the window that opens up (VBA Editor).This assumes your Bid Cell is A4 and your Status Cell is B4. Change to match your spreadsheet. Does that work for you?Please Login or Register to view this content.
Last edited by ChemistB; 05-13-2010 at 02:16 PM.
Hi,
Yes, just add the following WorkSheet Change event. I named the A1 cell 'YesNo' hence the reference in the macro.
RgdsPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks