+ Reply to Thread
Results 1 to 2 of 2

Ignore data validation if other cell's data has not yet been entered

  1. #1
    Registered User
    Join Date
    09-19-2018
    Location
    Unitd States
    MS-Off Ver
    2010
    Posts
    3

    Ignore data validation if other cell's data has not yet been entered

    Hello! I am creating an excel spreadsheet and have a section where the user enters a start date (E1) and another cell where they enter an end date (F1). I have set it using data validation that the date in E1 must be less than the date in F1 and the date in F1 must be greater than the date in E1.

    However, I don't want it to do such comparisons when E1 or F1 is blank. Currently, if I delete E1 and then try to enter a new value for F1, it sometimes won't let me depending on the date I enter into F1. If one cell (either E1 or F1) is blank, I want to be able to enter any value in the other cell. Is this possible? How?

    Thanks!

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Ignore data validation if other cell's data has not yet been entered

    Why don't you use a sheet specific macro?

    Right Click on your sheet name at the bottom of excel and select view code

    Paste this code into the module that opens and close it.

    Please Login or Register  to view this content.
    Last edited by mehmetcik; 09-19-2018 at 06:23 PM.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

+ 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. Ignore items in a data validation list based on another cell value
    By xpiotouopoc in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-13-2018, 10:34 AM
  2. Replies: 6
    Last Post: 04-03-2018, 02:18 PM
  3. Data Validation Restricts a Cell Based on Value Entered
    By STBTC in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-10-2017, 03:00 AM
  4. Condition Formatting: when one cell had data entered, ignore another
    By FarazM in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-24-2014, 06:16 PM
  5. [SOLVED] Data validation only returns data from the drop down list but not when entered!
    By carlandtina02 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-23-2013, 08:04 AM
  6. Replies: 8
    Last Post: 01-23-2013, 03:36 AM
  7. Replies: 9
    Last Post: 10-25-2011, 10:33 AM

Tags for this Thread

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