Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Mar 2012
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Validation Cell Formulas

    Hi everyone,

    I'm trying to create a data validation cell with a drop-down menu that is only available if another cell does not have a value. For exmaple, if the data validation cell is A2 and the cell it is conditional to is A1, I would like A2 to give a list of options only if A1 is blank or 0. I tried entering the formula: =IF(A1=0,"",C4:C10) but that doesn't seem to work. Can anyone give me some help on this?

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    This describes how to create dependent lists: http://contextures.com/xlDataVal02.html

    Steve

Tags for this 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
  •