Conditional Formattting

[JaguarF1_Uk]

Hi,

I have a database with PC, telephone and user asset information and they are
all linked by a unique identifier.

I have then created objects for these items within my visio diagram. What I
want to do is set the colour of these objects based on their location (for
which there is a field within the database already).

For example,

IF the PC object is connected to a property with "Location" = "Finance",
then colour the object Red.
However, if the PC object has a "Location" of "Personel", then colour the
object in blue.

I already have a "Prop.Location" field within the "Custom Properties"
options of my objects, so I know the code goes along the lines of

"=IF(Prop.Location="Finance", <set colour to red>,
(IF(Prop.Location="Personel", <set colour to blue>, <otherwise set object to
no fill>))

If anyone can shed any light, it would be greatly appreciated.

Many thanks,

 

[David Parker [Visio MVP]]

If you are updating your shape properties from your database, then why not
add a color field in your location table, then update the FillForegnd cell
also?

Alternatively, if you are using Visio 2003 Prof. then the Color By Value
addin can be used.

There are other ways using INDEX & LOOKUP in User cells too...