+ Reply to Thread
Results 1 to 4 of 4

if condition in data validation - when false allow to type

  1. #1
    Registered User
    Join Date
    02-24-2020
    Location
    India
    MS-Off Ver
    2010
    Posts
    23

    if condition in data validation - when false allow to type

    I want to create a data validation list, with if condition.

    When the condition meets true it should show the list and if false then it should allow to enter value manually.

    How to do this.

    Thanks in advance

  2. #2
    Valued Forum Contributor
    Join Date
    04-24-2020
    Location
    Woodbridge, VA
    MS-Off Ver
    2016
    Posts
    434

    Re: if condition in data validation - when false allow to type

    Hi - can you attach a sample of your file?

  3. #3
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: if condition in data validation - when false allow to type

    Use a DV type of List, and a formula such as

    =IF(A1="x",myList, "")

  4. #4
    Registered User
    Join Date
    02-24-2020
    Location
    India
    MS-Off Ver
    2010
    Posts
    23

    Re: if condition in data validation - when false allow to type

    Thanks for your reply,
    =IF(A1="x",myList, "")
    this formula will give a blank space when condition meets FALSE, and wont allow to enter any value manually
    I want to enter something manually when condition meets FALSE.

    thanks in advance.

+ 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. Data (Text) Validation between 2 cells to return True or False
    By Lauris K in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-24-2019, 12:28 PM
  2. [SOLVED] Data Validation for ComboBox on userform...display MsgBox if value is false?
    By Kamal1234 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-09-2018, 10:14 AM
  3. how to copy data from the textbox if condition is true or false???
    By clinton96 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-03-2016, 03:03 AM
  4. Data Validation when type Yes drop down come 1,2,3
    By AaruJaan in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-27-2016, 02:23 PM
  5. [SOLVED] Data Validation to disable user enter any value to the cells if condition false
    By Faridwahidi in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-03-2014, 05:49 AM
  6. Replies: 11
    Last Post: 06-27-2008, 04:39 PM
  7. Replies: 2
    Last Post: 11-28-2005, 08:40 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