Colour shape from label value?

[John]

I am using Visio 2003 to display an org chart. I am using the wizard found
at add-ons/building plans/label shapes to import data for the shape labels
from an excel spreadsheet. One of the fields I am importing is the name of
the person who is filling a position. If a position is not filled then the
data that is returned is "00". What I want to do is have any shape with "00"
in the name field to be filled with the colour red.

Is this possible?

 

[David Parker]

Have you tried the Color By Value add-on under Maps and Floor Plans?

 

[Philippe C.]

Dear John,

I am sorry, but I don't know why the solution I propose does not work.
The default property is "Value", is not it ?

In the Shapesheet, change cell FillForegnd to :
=IF(Prop.Name="",2,HSL(0,0,240))

 

[John]

Hi David

As far as I could tell, the Color by Value, doesn't allow me to define any
variables. I can only select the color according to the value that is
already there?

 

[John]

Hi Philippe,

Are you saying it won't work for you? I'm not sure what you mean, but it
doesn't work for me.

If it should work for me, how do I set "Prop.Name" to the property name that
I want it to look at? When I tried to use the property name instead of
"Name", it said there was an error.

 

[Philippe C.]

I just found the solution in the dutch discussion group (in dutch).
I probably forgot the "getref" to the property.
I don't have time at this moment to test it.

 

[Philippe C.]

getref or no getref, my formula allways equals to true, HELP !

 

[David Parker]

Use STRSAME for testing text equality:
STRSAME(Prop.Name,"")
NOT
Prop.Name=""

 

[Philippe C.]

The solution =IF(STRSAME(Prop.Name,"00"),2,3)
in the cell FillForegnd.
To my defence, strsame is not to be found in the SDK dvsdoc.pdf. An Office
function ?

 

[John]

All hail Philippe!

This works perfectly!

The solution =IF(STRSAME(Prop.Name,"00"),2,3)
in the cell FillForegnd.
To my defence, strsame is not to be found in the SDK dvsdoc.pdf. An Office
function ?