Dynamic Shapes

[MichaelJ300]

Hello,

I'm looking for a way to change my shapes based on a value. Either by a formula or code.

I have a ton of numbers that I want to show with arrows for positive/negative/flat. (Green Arrow up/Red Arrow down/Sideways Arrow)




Thanks in advance for any help on this!

 

[FracinDean]

I learned how to do this using macro recorder. Turn on the recorder, then insert an object, and start editing the properties, rotate, flip, change colors, borders, resize, drag to a new location, etc. You will see in the code how to refer to the different objects and how to make them move, etc. Then you can just use cell values from your sheet to make the changes to the objects.

 

[Taul]

Hi,
Take a look at Conditional Format (on the Home ribbon)
Conditional Format - Icon Sets.
use the 4 or 5 coloured arrow sets
This provides a green arrow up, red arrow down and a yellow arrow sideways depending on the cell value.

I hope this is what you need.

cheers
Paul.

 

[MichaelJ300]

Thanks! I will try this.

 

[MichaelJ300]

Conditional formatting will not help with scenario. Thanks though much appreciated!