Conditional Formatting Visio 2007

Started by cpsriskanalyst, July 28, 2008, 07:03:55 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Visio Guy

#15
Ah, a proper pint for Paul!

And for me, it's a bier :)
For articles, tips and free content, see the Visio Guy Website at http://www.visguy.com
Get my Visio Book! Using Microsoft Visio 2010

Visio Guy

One more note on my last example:

There are two lists that we are considering: a list of states, and a list of colors.

We get an index of which state is selected by using the LOOKUP function. This value is then used to "index into" our list of colors.

On first glance, it almost looks like we are doing a circle by "indexing a lookup", but since we have two lists, it actually makes sense.
For articles, tips and free content, see the Visio Guy Website at http://www.visguy.com
Get my Visio Book! Using Microsoft Visio 2010

wapperdude

An understated point of power and efficiency of this approach, not immediately obvious to some of us slower folks, is that the color index list is not restricted to the values and the order shown.  So, CA doesn't have to be white.  The 1,2,3,4 index could be 5,8,6,9 yielding:

California is yellow (5)
Florida is brown ( 8 )
Illinois is pink (6)
Virginia is drk green (9)

Thanks Visio Guy!

;D
Visio 2019 Pro

Paul Herber

Electronic and Electrical engineering, business and software stencils for Visio -

https://www.paulherber.co.uk/

Paul Herber

Quote from: cpsriskanalyst on July 29, 2008, 05:59:11 PM
nevermind, i inserted this for my formula and it worked great. 

= "-lookup(Prop.Sep, " & Chr$(34) & "1;2;3;4;5" & Chr$(34) & ")"
thanks again though for all your help, I don't know where i'd be without it!!!!
~G

Ah yes, that's because your lookup formula contained " characters so the first one effectively closed the formula. As you may have realised chr$(34) is character 34decimal = 22hex = the doublequotes character. I think you can do the same thing by putting the doublequotes character twice.

Electronic and Electrical engineering, business and software stencils for Visio -

https://www.paulherber.co.uk/