Creating a popup using data validation

[andrewb90]

I am trying to set up a popup box that appears if no data or a number not between 1 and 12 appears in box D1 on the welcome page.
In the data validation screen, I select allow custom, and uncheck ignore black and put in this formula, but even when I have an acceptable variable in D1 it still pops up.
=IF(Welcome!D1="",FALSE,IF(OR(Welcome!D1<1,Welcome!D1>12),FALSE,TRUE))
What am I doing wrong here?
Any help would be appreciated.

Thanks,
Andrew

 

[Jerry Sullivan]

Hi Andrew,

When I enter the formula that you posted in DataValidation (DV) Custom > Formula, I get an error message that ~You cannot use references to other worksheets.

When I removed !Welcome and used just the formula below, it works as you intended (I get the popup message for numbers outside of 1-12 and blanks, but no message upon entering numbers 1-12).

=IF(D1="",FALSE,IF(OR(D1<1,D1>12),FALSE,TRUE))

BTW, You don't need to use the DV Custom formula option for what you are doing.

Instead choose...
Allow: Whole number
Data: between
Minimum: 1
Maximum: 12