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!

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

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

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

This looks promising! Thank you for the help