Data validation possibility

[mdileep]

In cell range L6 to L12 I want to fill value between 220 to 250 or wrote text as NA.
is it possible by data validation in excel-2007.
Thanks!

 

[etaf]

i dont know 2007 that well, any longer, been a while since used

Select L6 to L12 in data validation
Custom
Put this formula
=OR(L6="NA",AND(L6>=220,L6<=250))
I have put for view the formula also in column N

Book15
	K	L	M	N
5
6		220		TRUE
7		250		TRUE
8		NA		TRUE
9				FALSE
10				FALSE
11				FALSE
12				FALSE
13
14
Sheet1

Cell Formulas
Range	Formula
N6:N12	N6	=OR(L6="NA",AND(L6>=220,L6<=250))

Cells with Data Validation
Cell	Allow	Criteria
L6:L12	Custom	=OR(L6="NA",AND(L6>=220,L6<=250))

 

[mdileep]

i dont know 2007 that well, any longer, been a while since used

Select L6 to L12 in data validation
Custom
Put this formula
=OR(L6="NA",AND(L6>=220,L6<=250))
I have put for view the formula also in column N

Book15
	K	L	M	N
5
6		220		TRUE
7		250		TRUE
8		NA		TRUE
9				FALSE
10				FALSE
11				FALSE
12				FALSE
13
14
Sheet1

Cell Formulas
Range	Formula
N6:N12	N6	=OR(L6="NA",AND(L6>=220,L6<=250))

Cells with Data Validation
Cell	Allow	Criteria
L6:L12	Custom	=OR(L6="NA",AND(L6>=220,L6<=250))

Thank you for early reply,
how is it possible to allow any text instead of NA, in same range
Thanks again.

 

[etaf]

Again, not looked into 2007
ISTEXT()
=OR(ISTEXT(L6),AND(L6>=220,L6<=250))

 

[mdileep]

Again, not looked into the 2007
ISTEXT()
=OR(ISTEXT(L6),AND(L6>=220,L6<=250))

Thanks, you have saved my much more time.

 

[etaf]

you are welcome