+ Reply to Thread
Results 1 to 6 of 6

Complicated - Errors/Dropdowns

  1. #1
    Registered User
    Join Date
    07-16-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    25

    Complicated - Errors/Dropdowns

    I have attached the excel file. Please read it as on the page it describes exactly what needs to be done.

    Here is what is written on the page. (Very complicated so any help is appriciated)

    How do I make it so that A's can clash, but B's cannot clash if they have the same option for A on the drop down menu. Eg.

    A = Option A
    B = Option C
    A = Option A
    B = Option D

    or

    A = Option A
    B = Option C
    A = Option B
    B = Option C

    are both fine

    but if

    A = Option A
    B = Option C
    A = Option A
    B = Option C

    occurs then both option C's show up as red.

    This has to work across all drop down boxes and only the two that are wrong can go red.

    Then for the special option, I want it to be so that no matter how many times and how its selected they never go red.

    Thanks

    P.S Any explanation will be appriciated as I will be doing it with varying amount of drop boxes.

    Thanks for your time

    Cheers,
    Tom
    Attached Files Attached Files

  2. #2
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Complicated - Errors/Dropdowns

    Use conditional formatting:

    1) Highlight D4:D15
    2) Select Home > Conditional Formatting > New Rule > Use a formula
    3) The formula will be:

    =AND(ISNUMBER(MATCH($D4, $L$4:$L$10, 0)), COUNTIF($D:$D, $D4)>1)

    and set the Format > Fill > Red
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    “None of us is as good as all of us” - Ray Kroc
    “Actually, I *am* a rocket scientist.” - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    07-16-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    25

    Re: Complicated - Errors/Dropdowns

    Thanks I will try this. May be a little complicated as I have Dutch Excel. Will get back to you. Thanks for your time.

  4. #4
    Registered User
    Join Date
    07-16-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    25

    Re: Complicated - Errors/Dropdowns

    Hate for it to be to much to ask, but would you mind putting it in the excel sheet and attaching it once you have put in the formulae. This way excel automatically and correctly changes the language of the coding because I tried to translate it myself and it gives an error code.

  5. #5
    Registered User
    Join Date
    07-16-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    25

    Re: Complicated - Errors/Dropdowns

    I managed to get it to work but it does not do as I wanted it to. Thanks ! Anyone else please really need help

    Cheers, Thomas

  6. #6
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Complicated - Errors/Dropdowns

    Here is your sheet back with the implementation. So far it does as you've outlined.
    Attached Files Attached Files

+ 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. Excel 2007 : filtering dropdowns with dropdowns?
    By CADiphile in forum Excel General
    Replies: 2
    Last Post: 10-15-2009, 04:11 PM
  2. Dropdowns and possible "sub dropdowns
    By LeonidasSaveUs! in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-01-2008, 09:55 PM
  3. Excel Throwing Circular Errors When No Errors Exist
    By MDW in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-10-2006, 09:20 AM
  4. DropDowns
    By Dharsh in forum Excel General
    Replies: 2
    Last Post: 04-28-2005, 08:06 AM
  5. Dropdowns
    By Carl Hilton in forum Excel General
    Replies: 1
    Last Post: 03-11-2005, 02:06 PM

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