Dropdown list - Words with spaces
Hey guys.
I got a dropdownlist in my Workbook and I know somehow it's possible to make it work ranged names with spaces, But I just can't make it work!
If you look at sheet1 I marked it as yellow, (GlasFärgat/GlasOfärgat) But I would want it to be possible to show "Glas (Färgat)" & "Glas (Ofärgat)"
That cell B10:B16 is dependent on cell D10 : D16. (D10 : D16 has a conditional formatting with Indirect function). But is it possible to sort it out to show my desired names or do I have to stick with the present? :S
|