## News:

BB code in posts seems to be working again!
I haven't turned on every single tag, so please let me know if there are any that are used/needed but not activated.

## Conditional Formatting Visio 2007

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

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!

Visio 2019 Pro

#### Paul Herber

mmmmmmmmm
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/

Browser ID: smf (possibly_robot)
Templates: 4: index (default), Display (default), GenericControls (default), GenericControls (default).
Sub templates: 6: init, html_above, body_above, main, body_below, html_below.
Language files: 4: index+Modifications.english (default), Post.english (default), Editor.english (default), Drafts.english (default).
Style sheets: 4: index.css, attachments.css, jquery.sceditor.css, responsive.css.
Hooks called: 226 (show)
Files included: 32 - 1207KB. (show)
Memory used: 1101KB.