+ Reply to Thread
Results 1 to 6 of 6

multiple validation in a single cell

  1. #1
    whowatwerwyhow
    Guest

    multiple validation in a single cell

    Is it possible to set multiple validation for a single cell in excel? Its
    pretty straight forward to set a single validation so that a message is
    displayed when incorrect data is entered. However, adding another validation
    seems to delete the old one. Thanks in advance.

  2. #2
    JulieD
    Guest

    Re: multiple validation in a single cell

    Hi

    you can do some of this under data / validation - custom
    but without more details we can't give you a specific answer.

    --
    Cheers
    JulieD
    check out www.hcts.net.au/tipsandtricks.htm
    ....well i'm working on it anyway
    "whowatwerwyhow" <[email protected]> wrote in message
    news:[email protected]...
    > Is it possible to set multiple validation for a single cell in excel? Its
    > pretty straight forward to set a single validation so that a message is
    > displayed when incorrect data is entered. However, adding another
    > validation
    > seems to delete the old one. Thanks in advance.




  3. #3
    whowatwerwyhow
    Guest

    Re: multiple validation in a single cell

    the sort of things i'd like 2 do r:

    - validate that the number entered is smaller than 2400
    - validate that the last 2 digits are never greater than 59
    - validate that the the number enetered is smaller/greater than other
    entries made in other cells, etc, etc.

    i can manage to do these individually as u sugested belo, i.e. using data ->
    validation. however, how can i do them all at the same time for a single cell?

    thanks.

    "JulieD" wrote:

    > Hi
    >
    > you can do some of this under data / validation - custom
    > but without more details we can't give you a specific answer.
    >
    > --
    > Cheers
    > JulieD
    > check out www.hcts.net.au/tipsandtricks.htm
    > ....well i'm working on it anyway
    > "whowatwerwyhow" <[email protected]> wrote in message
    > news:[email protected]...
    > > Is it possible to set multiple validation for a single cell in excel? Its
    > > pretty straight forward to set a single validation so that a message is
    > > displayed when incorrect data is entered. However, adding another
    > > validation
    > > seems to delete the old one. Thanks in advance.

    >
    >
    >


  4. #4
    JulieD
    Guest

    Re: multiple validation in a single cell

    Hi

    well here's the formula to meet the first two criteria ... as you didn't
    specify the rest, hopefully you'll be able to figure it out from here
    choose
    data / validation
    choose
    custom
    type
    =AND(A1<2400,VALUE(RIGHT(A1,2))<=59)


    --
    Cheers
    JulieD
    check out www.hcts.net.au/tipsandtricks.htm
    ....well i'm working on it anyway
    "whowatwerwyhow" <[email protected]> wrote in message
    news:[email protected]...
    > the sort of things i'd like 2 do r:
    >
    > - validate that the number entered is smaller than 2400
    > - validate that the last 2 digits are never greater than 59
    > - validate that the the number enetered is smaller/greater than other
    > entries made in other cells, etc, etc.
    >
    > i can manage to do these individually as u sugested belo, i.e. using
    > data ->
    > validation. however, how can i do them all at the same time for a single
    > cell?
    >
    > thanks.
    >
    > "JulieD" wrote:
    >
    >> Hi
    >>
    >> you can do some of this under data / validation - custom
    >> but without more details we can't give you a specific answer.
    >>
    >> --
    >> Cheers
    >> JulieD
    >> check out www.hcts.net.au/tipsandtricks.htm
    >> ....well i'm working on it anyway
    >> "whowatwerwyhow" <[email protected]> wrote in
    >> message
    >> news:[email protected]...
    >> > Is it possible to set multiple validation for a single cell in excel?
    >> > Its
    >> > pretty straight forward to set a single validation so that a message is
    >> > displayed when incorrect data is entered. However, adding another
    >> > validation
    >> > seems to delete the old one. Thanks in advance.

    >>
    >>
    >>




  5. #5
    whowatwerwyhow
    Guest

    Re: multiple validation in a single cell

    Thanks, that wrkd.

    "JulieD" wrote:

    > Hi
    >
    > well here's the formula to meet the first two criteria ... as you didn't
    > specify the rest, hopefully you'll be able to figure it out from here
    > choose
    > data / validation
    > choose
    > custom
    > type
    > =AND(A1<2400,VALUE(RIGHT(A1,2))<=59)
    >
    >
    > --
    > Cheers
    > JulieD
    > check out www.hcts.net.au/tipsandtricks.htm
    > ....well i'm working on it anyway
    > "whowatwerwyhow" <[email protected]> wrote in message
    > news:[email protected]...
    > > the sort of things i'd like 2 do r:
    > >
    > > - validate that the number entered is smaller than 2400
    > > - validate that the last 2 digits are never greater than 59
    > > - validate that the the number enetered is smaller/greater than other
    > > entries made in other cells, etc, etc.
    > >
    > > i can manage to do these individually as u sugested belo, i.e. using
    > > data ->
    > > validation. however, how can i do them all at the same time for a single
    > > cell?
    > >
    > > thanks.
    > >
    > > "JulieD" wrote:
    > >
    > >> Hi
    > >>
    > >> you can do some of this under data / validation - custom
    > >> but without more details we can't give you a specific answer.
    > >>
    > >> --
    > >> Cheers
    > >> JulieD
    > >> check out www.hcts.net.au/tipsandtricks.htm
    > >> ....well i'm working on it anyway
    > >> "whowatwerwyhow" <[email protected]> wrote in
    > >> message
    > >> news:[email protected]...
    > >> > Is it possible to set multiple validation for a single cell in excel?
    > >> > Its
    > >> > pretty straight forward to set a single validation so that a message is
    > >> > displayed when incorrect data is entered. However, adding another
    > >> > validation
    > >> > seems to delete the old one. Thanks in advance.
    > >>
    > >>
    > >>

    >
    >
    >


  6. #6
    JulieD
    Guest

    Re: multiple validation in a single cell

    you're welcome and thanks for the feedback

    "whowatwerwyhow" <[email protected]> wrote in message
    news:[email protected]...
    > Thanks, that wrkd.
    >
    > "JulieD" wrote:
    >
    >> Hi
    >>
    >> well here's the formula to meet the first two criteria ... as you didn't
    >> specify the rest, hopefully you'll be able to figure it out from here
    >> choose
    >> data / validation
    >> choose
    >> custom
    >> type
    >> =AND(A1<2400,VALUE(RIGHT(A1,2))<=59)
    >>
    >>
    >> --
    >> Cheers
    >> JulieD
    >> check out www.hcts.net.au/tipsandtricks.htm
    >> ....well i'm working on it anyway
    >> "whowatwerwyhow" <[email protected]> wrote in
    >> message
    >> news:[email protected]...
    >> > the sort of things i'd like 2 do r:
    >> >
    >> > - validate that the number entered is smaller than 2400
    >> > - validate that the last 2 digits are never greater than 59
    >> > - validate that the the number enetered is smaller/greater than other
    >> > entries made in other cells, etc, etc.
    >> >
    >> > i can manage to do these individually as u sugested belo, i.e. using
    >> > data ->
    >> > validation. however, how can i do them all at the same time for a
    >> > single
    >> > cell?
    >> >
    >> > thanks.
    >> >
    >> > "JulieD" wrote:
    >> >
    >> >> Hi
    >> >>
    >> >> you can do some of this under data / validation - custom
    >> >> but without more details we can't give you a specific answer.
    >> >>
    >> >> --
    >> >> Cheers
    >> >> JulieD
    >> >> check out www.hcts.net.au/tipsandtricks.htm
    >> >> ....well i'm working on it anyway
    >> >> "whowatwerwyhow" <[email protected]> wrote in
    >> >> message
    >> >> news:[email protected]...
    >> >> > Is it possible to set multiple validation for a single cell in
    >> >> > excel?
    >> >> > Its
    >> >> > pretty straight forward to set a single validation so that a message
    >> >> > is
    >> >> > displayed when incorrect data is entered. However, adding another
    >> >> > validation
    >> >> > seems to delete the old one. Thanks in advance.
    >> >>
    >> >>
    >> >>

    >>
    >>
    >>




+ 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