Results 1 to 3 of 3

Conditional Format on 2nd drop down menu - Invalid option

Threaded 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

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