validation command

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 31 pages each with the same range I want to progam to validate the entry. it works fine for page 1, but when I highlight more than 1 worksheet to do them all at once the Validation comand is unavalible. The worksheets are unprotected. It is not a shared workbook. Is there a way to program validation to all at once or at least copy, paste validation?
 
Nevermind that question, while i was typing the question I thought of copy paste and it does apear to work, but the custom formula for validation does not seem to be working, I want to warn unless a number between 1 & 60 is entered or the letter "N" entered. I tried - or(and(>1,<60),<>="n") -- but any number entry gives me the warning ?
 
The following will allow 2 to 59 or "n". Assuming that you enter this first
for A1 and then copy to other cells :

=OR(AND(A1>1,A1<60),A1="n")

hth,

Doug

R Mills said:
Nevermind that question, while i was typing the question I thought of copy
Click to expand...
paste and it does apear to work, but the custom formula for validation does
not seem to be working, I want to warn unless a number between 1 & 60 is
entered or the letter "N" entered. I tried - or(and(>1,<60),<>="n") --
but any number entry gives me the warning ?
 
Back
Top