Print Page - Color fill change based on shape width

Title: Color fill change based on shape width
Post by: blurry on December 14, 2020, 04:26:08 PM

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!

Title: Re: Color fill change based on shape width
Post by: Surrogate on December 14, 2020, 05:00:44 PM

For example put this formula to FillForegnd cell

Code Select

IF(Width<10 mm,2,IF(Width>30 mm,3,4))
(https://i.ibb.co/s51g059/2020-12-14-20-06-24.png)
In this case i use Visio's color constanst, not RGB colors.
(http://forumimage.ru/uploads/20160221/145608220051857697.png) (https://visio.getbb.ru/viewtopic.php?f=6&t=788)

Title: Re: Color fill change based on shape width
Post by: blurry on December 14, 2020, 05:29:04 PM

Awesome, thank you very much for the help!

Visio Guy

Visio Discussions => ShapeSheet & Smart Shapes => Topic started by: blurry on December 14, 2020, 04:26:08 PM