Michiel
Michiel

Reputation: 91

How to let visio shapes change behaviour from their text?

I have shapes that should change behaviour on the basis of their text.

Text fields change their height and with using =GUARD(TEXTWIDTH(TheText)) just fine.

But when I try to let something change color like this =THEMEGUARD(IF(LEN(TheText)>3,RGB(255,112,192),RGB(0,112,192))) nothing happens when you change the text.

Any ideas on how to get visio to actually run this like it should? Or am I doing something wrong here?

Upvotes: 0

Views: 122

Answers (1)

Surrogate
Surrogate

Reputation: 1734

Or am I doing something wrong here?

Please try add SHAPETEXT function.

With syntax like =THEMEGUARD(IF(LEN(SHAPETEXT(TheText))>3,RGB(255,112,192),RGB(0,112,192)))

Test of this formula result

I check this formula at my side, it works!

Upvotes: 2

Related Questions