Excel Multiple choice example.zip
Thanks for the reply, but, those don't seem to be quite what I'm looking for (unless I'm just not understanding them at all - which is always a possibility).
The document manager has an upload button now, so I'm attaching the example I wanted to attach before.
In the picture above, the selection of "Red" fills in the seat style as "bucket" and the Interior Color as "white, black or gray".
For "Black", I tried creating a list of values instead of just putting all the colors together in the cell. My hope was that, when "Black" was selected, it would then have the list of values to be selected in the seat style.
However, the selection from the list of values still has to be made in the source list (in cell C:10) - and that is not feasible, as I would like to keep the lists that drive the selections hidden (in the real spread sheet, there are several tabs, one of which is "background data" which will be hidden, just to keep things clean).
In the pictures below - I'm trying to get B:4 to have a functioning list of values, but, it only pulls what has been selected in C:10.
I'm trying to get each of the cells which have choices to present the choices as a list of values, as the results of B:4 and B:5 will drive information in other parts of the worksheet.