hello,

i'm trying to figure out if it is possible to do this:
- cell with a dropdownlist of 'red, green 'amber'
- a shape on another sheets gets the color from the dropdownlist

so fill color is green of 'green' is seldted from the dropdownlist

Does anyone has an example worksheet for this?
thanks!
W