Hi, i was wondering how exactly those fancy drop down- to select color menus of some shapes work. I get the point with the lists and how to make them, but how can i set the color of the shape depending on a special value?
Lets assume i have a drop down menu:
Video
Audio
Network
and depending on what is selected i want the color of the shape to be red, green or blue.
How exactly would this work?
I thought about using IF(), but i dont know how to get from a string to a boolean value.
Or is there like an incredibly easy way i´m just too blind to see?
You can get the index of selected item in dropdown menu with LookUp function. Check the formulas in attached sample shape.
Perfect, Thank you very much!