+ Reply to Thread
Results 1 to 3 of 3

Conditional Format on 2nd drop down menu - Invalid option

Hybrid View

  1. #1
    Registered User
    Join Date
    05-31-2013
    Location
    England
    MS-Off Ver
    Office 365
    Posts
    81

    Conditional Format on 2nd drop down menu - Invalid option

    I have two drop down menus, the 2nd menu is an indirect formula on the 1st menu. Let's say Drop down 1 is selected and then 2 is selected, then the user decides to change drop down 1, the option in 2 is no longer valid.

    How do I do a conditional format on drop down 2?

    This is what I currently have but does not work:
    Conditional Format in F16; =indirect($D$16)<>$F$16
    D16 = Drop down 1
    F16 = Drop down 2

    *I already have a VBA which auto clears out the 2nd drop down if the 1st one is changed, however not every user has the newest Excel*

    Thanks
    Last edited by MushroomFace; 01-11-2016 at 02:11 PM.
    If you like my answer please *Add Reputation

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Conditional Format on 2nd drop down menu - Invalid option

    You could conditionally format the second dropdown to turn red if it needs to be updated.

    What versions of Excel are others using that your macro doesn't work for them?

    Anyway, here's an example. with the first dropdown in A1 and the second (dependent) dropdown in B1, I set this Conditional Formatting

    =ISERROR(VLOOKUP($B$1, INDIRECT($A$1),1,FALSE))
    So if it can't find the value in B1 on the list in A1, it will change color.
    Attached Files Attached Files
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Registered User
    Join Date
    05-31-2013
    Location
    England
    MS-Off Ver
    Office 365
    Posts
    81

    Re: Conditional Format on 2nd drop down menu - Invalid option

    Makes sense. Perfect. Thank you

+ 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. Conditional Formatting of Drop-down Menu b/n Two Sheets
    By ElectricChode in forum Excel General
    Replies: 1
    Last Post: 10-18-2015, 01:28 PM
  2. Conditional Drop Down Menu - multiple variables
    By mattmega4 in forum Excel General
    Replies: 7
    Last Post: 07-10-2015, 10:27 AM
  3. [SOLVED] Conditional Drop Down Menu
    By BigBadBill in forum Excel General
    Replies: 3
    Last Post: 12-24-2013, 04:47 PM
  4. Need help creating a calendar in a drop menu format
    By Warren Short in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-02-2013, 06:43 PM
  5. Conditional Format with drop down menu
    By fobioha in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-24-2012, 05:01 PM
  6. format cell with drop down menu?
    By benjii19 in forum Excel General
    Replies: 3
    Last Post: 08-04-2010, 09:33 AM
  7. drop down menu and conditional formatting
    By Demelza in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-18-2006, 05:15 PM

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