+ Reply to Thread
Results 1 to 5 of 5

Create data validation formula so pop up box appears when a number is entered

  1. #1
    Registered User
    Join Date
    08-15-2018
    Location
    Varies
    MS-Off Ver
    2013
    Posts
    10

    Create data validation formula so pop up box appears when a number is entered

    How do I create a Data Validation formula for Column C? If a person tries to enter a number in Column C when an "X" is in a cell in Column B, would like a pop up box to open that says "Miles Not Allowed". Would prefer not to have to create a VBA formula. Also, would I need two different formulas for Column C if a person enters a capital "X" or a lower case "x" in Column B?

    A B C
    Day Vacation Miles
    Mon X
    Tues X
    Wed 250
    Thurs 50
    Fri 20

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Create data validation formula so pop up box appears when a number is entered

    Try this:

    Highlight C2:C6 > Data > Data Validation > Custom: =B2<>"X" > Error Alert > Error message: Miles Not Allowed > OK

    Case (x vs X) does not matter.

  3. #3
    Registered User
    Join Date
    08-15-2018
    Location
    Varies
    MS-Off Ver
    2013
    Posts
    10

    Re: Create data validation formula so pop up box appears when a number is entered

    Thank you!

  4. #4
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Create data validation formula so pop up box appears when a number is entered

    You're welcome. Happy to help.

  5. #5
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Re: Create data validation formula so pop up box appears when a number is entered

    lagatorbug

    We're very pleased that 63falcondude managed to solve your issue satisfactorily.
    Before you post in future, please read the rules, paying particular attention to rule 8 regarding cross-posting.

    DominicB
    Please familiarise yourself with the rules before posting. You can find them here.

+ 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. Replies: 4
    Last Post: 08-28-2017, 07:35 PM
  2. Need to create a Data Validation (list) Formula
    By stax290 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-22-2017, 03:27 AM
  3. [SOLVED] Create sequencial number list to use for Data Validation
    By llamafarmer in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-01-2016, 07:35 AM
  4. Replies: 1
    Last Post: 07-18-2013, 10:11 AM
  5. [SOLVED] Create a custom formula for data validation
    By barbercabinet58 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-09-2012, 02:59 PM
  6. Replies: 2
    Last Post: 07-24-2012, 09:18 AM
  7. Highlight if Data entered appears in another workbook
    By mg_sv_r in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-23-2006, 10:45 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