Forum Discussion
Solved
Creating a Dependent Drop Down List from Multiple Data (Multiple Select using VBA) in One Cell
Hi Community, I'm trying to create a second dependent drop down list but the data I want it to be dependent on as multiple data value in a cell which is inserted from a drop down list. I have use...
HansVogelaar you are a legend. Thank you so much. Can I apply conditional formatting to this?
Yes, but the implementation depends on what exactly you want to do.
- Ok so now want I want is that for each technology area that is selected appears in a different colour and then the different portfolio areas appears in the same colour as the technology area.
So you want different colors within the same cell. That is not possible using conditional formatting, for that is always applied to an entire cell. It would require VBA. It would be complicated, I'll see if I can come up with something. I don't have time for that immediately.
- Thats fine, no problem. Whenever you can would be great.