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,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
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))
Thanks, you have saved my much more time.Again, not looked into the 2007
ISTEXT()
=OR(ISTEXT(L6),AND(L6>=220,L6<=250))