Forum Discussion
Dropdown within a dropdown?
Hi brilliant excel wizards! I have a sheet that contains the dropdown options for a budget. I used data validation on another sheet to create the dropdown. The problem is that there are a LOT of ...
I'd use two cells: one with a drop-down list of the categories, and the other with a drop-down list of the options for the category selected in the first one.
- Thanks! I was hoping to avoid using a second cell. Is there a way to actually show color in the dropdown list? As far as I can tell, it looks like that is only possible with conditional formatting once the selection has been made.
You are correct - it is not possible to color items in a drop-down list.
