Results 1 to 4 of 4

Dependent Data Validation Lists and the rule of no spaces in named ranges

Threaded View

  1. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: Dependent Data Validation Lists and the rule of no spaces in named ranges

    You may include another feature to the dependent data validation list.

    Like when you change your selection in A2, the dependent drop down list in B2 still contains the old selection if it was selected earlier. So you may apply the conditional formatting to hide the previous selection if any in case you change the selection in A2.

    Formula used to make a New Rule for conditional formatting for the cell B2 is....

    =COUNTIF(INDIRECT(VLOOKUP(A2,vlookup_table,2,FALSE)),B2)=0
    And custom format B2 with ;;; through conditional formatting.
    Attached Files Attached Files
    Last edited by sktneer; 03-29-2015 at 12:42 AM.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Dependent List Validation from Dynamic Named Ranges
    By freeride in forum Excel General
    Replies: 11
    Last Post: 01-22-2020, 03:07 PM
  2. [SOLVED] Dependent data validation with dynamic named ranges
    By Ace_XL in forum Excel General
    Replies: 4
    Last Post: 08-07-2014, 10:02 AM
  3. Replies: 3
    Last Post: 07-28-2014, 03:16 PM
  4. [SOLVED] Can't use Numbers in named range list for Dependent data validation lists
    By Sam Kuiper in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 11-11-2012, 08:26 PM
  5. Help with Named Ranges used in Validation Lists
    By BarbaraNie in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-09-2012, 10:04 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