+ Reply to Thread
Results 1 to 4 of 4

Data Validation with AND statement

Hybrid View

  1. #1
    Registered User
    Join Date
    01-05-2010
    Location
    Arlington, VA
    MS-Off Ver
    Excel 2007
    Posts
    19

    Unhappy Data Validation with AND statement

    I have a company travel spreadsheet seperated by month (each month on seperate tab currenlty hidden in file) that I want to use Data Validation in order to have a pop-up message box appear warning travelers they entered travel dates indicating travel of more than 7 days. Attached is a copy of the spreadsheet with the data validation already there, in Column H.

    Currently, the pop up message happens no matter how many days, be that 10 tens or 2 days, the warning box still pops up even if it's not true. The formula for the data validation is based upon the value in cell I, which is a formula.

    How can I get the pop up message to correctly only pop up when cell I2 (I3, I4, etc) is greater than 7?
    I have tired all different kinds of options but nothing seems to work.

    Once I can get this fixed I will need to apply this to all the "monthly" tabs in the spreadsheet.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,034

    Re: Data Validation with AND statement

    Try:
    Formula: copy to clipboard
    =AND($G2<>"",$H2<>"",$I2<=7)



    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    01-05-2010
    Location
    Arlington, VA
    MS-Off Ver
    Excel 2007
    Posts
    19

    Re: Data Validation with AND statement

    Yes, that seems to have done the trick!! Thank you!!! I will play around with this some more just to be sure but will mark as solved soon. Thanks again.

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,034

    Re: Data Validation with AND statement

    You're welcome. Thanks for the rep.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] IF statement on data Validation
    By Faridwahidi in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-13-2014, 04:17 AM
  2. If Statement & Data Validation Help
    By scoste in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-22-2014, 12:38 PM
  3. [SOLVED] Data VAlidation With If statement
    By excobra in forum Excel General
    Replies: 6
    Last Post: 11-12-2013, 05:28 AM
  4. DATA Validation and IF statement
    By NCAA in forum Excel General
    Replies: 3
    Last Post: 03-29-2012, 04:01 AM
  5. Data validation IF statement
    By christopherp in forum Excel General
    Replies: 4
    Last Post: 11-12-2009, 11:27 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1