Colour shape from label value?

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?

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

"John" wrote in message
...
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?

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" wrote:

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?

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?

"David Parker" wrote:

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

"John" wrote in message
...
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?

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." wrote:

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" wrote:

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?

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.

"John" wrote:

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." wrote:

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" wrote:

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?

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

"Philippe C." wrote:

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.

"John" wrote:

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." wrote:

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" wrote:

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?

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

"Philippe C." wrote in message
...
getref or no getref, my formula allways equals to true, HELP !

"Philippe C." wrote:

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.

"John" wrote:

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." wrote:

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" wrote:

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?

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" wrote:

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." wrote:

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" wrote:

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?

All hail Philippe!

This works perfectly!

"Philippe C." wrote:

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" wrote:

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." wrote:

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" wrote:

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?