Dynamic Shapes

MichaelJ300

Board Regular
Joined
Oct 30, 2013
Messages
131
Office Version
2016
Platform
Windows
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!
 

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

FracinDean

Board Regular
Joined
Jul 11, 2011
Messages
65
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.
 
Last edited:

Taul

Well-known Member
Joined
Oct 24, 2004
Messages
656
Office Version
2013, 2010
Platform
Windows
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

Board Regular
Joined
Oct 30, 2013
Messages
131
Office Version
2016
Platform
Windows
Conditional formatting will not help with scenario. Thanks though much appreciated!
 

Forum statistics

Threads
1,089,227
Messages
5,406,988
Members
403,116
Latest member
HKLeung

This Week's Hot Topics

Top