+ Reply to Thread
Results 1 to 5 of 5

Conditional Formatting for Lists (I think)

  1. #1
    Registered User
    Join Date
    01-22-2021
    Location
    Houston, TX
    MS-Off Ver
    20122
    Posts
    3

    Conditional Formatting for Lists (I think)

    Howdy All,

    I'm beginning to do some root cause analysis where I'm finding myself needing to use multiple lists. So, in column A, the user would select a high level system that failed. Then in column B, the user would select which component in that system failed. Obviously, the list of components available to select in column B would be dependent on the system selected in column A. I'm needing to find the best way to accomplish this. I'm fairly well-versed in excel, and can generally google-solve my own problems, but I'm not sure what to call this type of conditional formatting to look it up! Any guidance would be appreciated!

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    22,511

    Re: Conditional Formatting for Lists (I think)

    It is referred to as dependent data validation. Debra Dalgleish explains it well on her website here:

    https://www.contextures.com/xldataval02.html

    Hope this helps.

    Pete

  3. #3
    Valued Forum Contributor
    Join Date
    01-16-2012
    Location
    England
    MS-Off Ver
    MS 365
    Posts
    1,308

    Re: Conditional Formatting for Lists (I think)

    engineerdude,

    Would you be interested in using Dependent DropLists for the choices?

    Have the "High level" systems in a DropList, Whichever system you choose then populates a "dependent" droplist, where the content is the components of your selected System, which can then "drill down" to the next Dependent list and so on.

    This site has a good explanation showing how to create dynamic and multiple dependent drop down lists

    https://www.ablebits.com/office-addi...op-down-excel/

    Hope this helps?

    Ochimus

  4. #4
    Registered User
    Join Date
    01-22-2021
    Location
    Houston, TX
    MS-Off Ver
    20122
    Posts
    3

    Re: Conditional Formatting for Lists (I think)

    Thank you! I'll look into doing it this way instead.

  5. #5
    Registered User
    Join Date
    01-22-2021
    Location
    Houston, TX
    MS-Off Ver
    20122
    Posts
    3

    Re: Conditional Formatting for Lists (I think)

    This looks promising! Thank you for the help

+ 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 and Priority Lists
    By 82ndGrizz in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-24-2015, 10:49 AM
  2. [SOLVED] Conditional formatting comparing two lists of different sizes
    By Steffen_DK in forum Excel General
    Replies: 6
    Last Post: 08-10-2013, 04:34 AM
  3. Conditional Formatting using Lists
    By darknation144 in forum Excel General
    Replies: 3
    Last Post: 02-17-2012, 06:53 AM
  4. Replies: 4
    Last Post: 03-31-2011, 01:50 PM
  5. Conditional formatting based on dependant lists
    By rmarroq in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-16-2009, 08:51 PM
  6. Conditional Formatting Validation Lists
    By kingsolo in forum Excel General
    Replies: 2
    Last Post: 01-11-2007, 05:32 AM
  7. Conditional Formatting to Compare to Lists
    By John Michl in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-07-2006, 11:20 AM

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