Results 1 to 15 of 15

Thread: [resolved] Validating list in excel

Threaded View

  1. Feb 22nd, 2006, 06:28 PM #1
    Siddharth Rout
    Siddharth Rout is offline

    Thread Starter
    Discovering Life Siddharth Rout's Avatar
    Join Date
    Feb 2005
    Location
    Mumbai, India
    Posts
    12,001

    Resolved [resolved] Validating list in excel

    Lets say there are two lists. list one has "apple,oranges,grapes" and list two has "in stock,out of stock, delay". i have validated cell A1 and B1 so that user can select items from list 1 and list 2 respectively. The question is if the user selects "apple" in A1 then B1 should display "expected" which of course is not in list 2 and the cell B1 should get locked. however when the user selects "oranges" or "grapes" in A1 then he should be able to select the items from list 2 in B1 and the cell should not get locked. I hope I make sense....

    Can anyone help me?
    Last edited by Siddharth Rout; Feb 28th, 2006 at 04:33 PM. Reason: RESOLVED
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width