Changing the shape colour from Custom properties

[Arnold]

Hi,
I would like to change the color of a shape by a corresponding custom
properties value (Visio 2003).

Lets say Prop.A has a value "Red, Blue, Green, Yellow"
Under Line Format, LineColor, I need the formula to hook up the
corresponding color number. I have been trying to do so by using the a
nested IF statement, but I am running out of options now.

Is there someone who can give me some help?
Thanks,
Arnold

 

[Arnold]

Sounds OK. I am going to look into it...
Thanks,
Arnold

 

[Arnold]

I managed to use the LOOKUP function up to that it changes the color value
from 1 -9 (corresponding colors)
I used this:
=LOOKUP(Prop.Name,Prop.Name.Format)
Do you know if there is there a way to have the Prop.Name value result in a
corresponding RGB value?
Arnold

 

[Arnold]

I just managed to do it, so thanks for the help.
Arnold