Dynamic Shapes

MichaelJ300

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

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
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:
Upvote 0
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.
 
Upvote 0
Conditional formatting will not help with scenario. Thanks though much appreciated!
 
Upvote 0

Forum statistics

Threads
1,213,539
Messages
6,114,221
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top