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.