0

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?

SwissCodeMen
  • 4,222
  • 8
  • 24
  • 34
Michiel
  • 57
  • 1
  • 6

1 Answers1

2

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!

Surrogate
  • 1,466
  • 2
  • 11
  • 13