Fallwind
Fallwind

Reputation: 23

Visio Shapesheet Conditional Formula

I am editing a master shape's shapesheet. I want to adjust the FillForegnd cell in the Fill Format section, which changes the shape's fill color. I want to write a formula for the fill to be one color if Prop.Name contains a certain word (in this case, "Vacant") and otherwise just use the theme color.

I tried this formula just to test the formula, but it did not work. Eventually I'd like to change it to look for whether the cell contains the text rather than equals the text, but in the meantime I couldn't even get this to work. Please advise.

=IF(Prop.Name = "VACANT",THEMEVAL("FillColor",RGB(165,0,0)),THEMEVAL("FillColor",RGB(99,139,173)))

Upvotes: 2

Views: 372

Answers (1)

Surrogate
Surrogate

Reputation: 1734

For compare strings in ShapeSheet you must use STRSAME function. Please try this syntax =IF(STRSAME(Prop.Name,"VACANT"),THEMEVAL("FillColor",RGB(165,0,0)),THEMEVAL("FillColor",RGB(99,139,173)))

Upvotes: 1

Related Questions