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.

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" wrote in message
...
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.

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" wrote in message
...
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.

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" wrote in message
...
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" wrote in
message
...
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.

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" wrote in message
...
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" wrote in
message
...
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.

you're welcome and thanks for the feedback

"whowatwerwyhow" wrote in message
...
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" wrote in
message
...
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" wrote in
message
...
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.