+ Reply to Thread
Results 1 to 3 of 3

data validation to restrict input in cell based on value of cell above that cell

  1. #1
    NC
    Guest

    data validation to restrict input in cell based on value of cell above that cell

    Hi all,

    i am creating a spread sheet in which users are supposed to enter data
    in one column. i want to add validation in such a way that user will
    not be able to enter data in the say cell "C1" if he has not entered
    value in cell "B1"i.e if "B1" is blank
    Can anybody plz help

    Thanks in advance

    Regards
    NC


  2. #2
    Rob van Gelder
    Guest

    Re: data validation to restrict input in cell based on value of cell above that cell

    A previous post by Debra Dalgleish
    http://groups.google.co.nz/groups?hl...turesXSPAM.com

    Select cell A2
    Choose Data>Validation
    Choose to Allow:Custom
    In the Formula box, type: =A1<>""
    Remove the check mark from 'Ignore blank'
    Click OK


    --
    Rob van Gelder - http://www.vangelder.co.nz/excel


    "NC" <[email protected]> wrote in message
    news:[email protected]...
    > Hi all,
    >
    > i am creating a spread sheet in which users are supposed to enter data
    > in one column. i want to add validation in such a way that user will
    > not be able to enter data in the say cell "C1" if he has not entered
    > value in cell "B1"i.e if "B1" is blank
    > Can anybody plz help
    >
    > Thanks in advance
    >
    > Regards
    > NC
    >




  3. #3
    NC
    Guest

    Re: data validation to restrict input in cell based on value of cell above that cell

    thanks rob

    it works fine

    regards
    NC


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1