Color fill change based on shape width

Started by blurry, December 14, 2020, 04:26:08 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

blurry

Hi, I am super new to the shape sheet, so I hope no one minds my simple questions.  I am wondering if there is a way to make a shape change colors based on its width.  The shape is bound to 2", 4", or 6", and I'd like each width to be a different color.  I have searched the boards and google, but I can't figure out what kind of formula to use or where to put it.  I'd greatly appreciate any help you have to offer this newbie.  Thanks!

Surrogate

#1
For example put this formula to FillForegnd cell
IF(Width<10 mm,2,IF(Width>30 mm,3,4))

In this case i use Visio's color constanst, not RGB colors.

blurry

Awesome, thank you very much for the help!