Restrict Data Entry if previous cell doesn't fall between a particular range

[dezspert22]

Hi,
I am using data validation to restrict entry in highlighted cell if previous cell does not contain the ranges between 1000000-2999999. I am confused on finding the proper formula to put in data validation.
For example. I have two cells, cell D7 ( Number) and cell G7 ( Order). I wanted to restrict entry in G7 (Order) if cell D7 (Numbers) is not between the range of 1,000,000 and 2,999,999.

[Tony Valko]

G7 data validation

Formula: =AND(D7>=1000000,D7<=2999999)

[dezspert22]

I go to Data>Data Validation>Custom and I input the formula you provided. When I test it, it's still allowing entry in G7 when I put 1000001 in cell D7.

[Tony Valko]

I go to Data>Data Validation>Custom and I input the formula you provided. When I test it, it's still allowing entry in G7 when I put 1000001 in cell D7.

Isn't that what you wanted?

G7 will only accept an entry if cell D7 contains a number between 1000000 and 2999999 (inclusive).

[dezspert22]

Oh no I'm saying if the numbers are not between 1000000 and 2999999 then allow input. Sorry for miscommunication.

[José Augusto]

Use customize data validation with the following formula in G7

Please Login or Register  to view this content.

[dezspert22]

Ok thank you it worked! I input in the wrong cell information but I got it! Thank you both!

[Tony Valko]

Good deal. Thanks for the feedback!