change shape colour based on cell value

[sainil]

I have some shapes like pupms, compressors etc on an excel sheet. How the colour of these shapes can be changed either red or greeen based on the cell values in another sheet of the same work book. If the cell value is +1 need green colour and and if -1 need red colour. I have excel 2013.

 

[nhantavan]

Hi Momentman,
I have a problem as topic "change shape colour based on cell value". I have a shape, when i Force value into a cell, color of shape changes. But when value of this cell auto change (force from another software (kepware)), color of shape not change. Can you help me?
Thanks a lot!

 

[Momentman]

Hi Momentman,
I have a problem as topic "change shape colour based on cell value". I have a shape, when i Force value into a cell, color of shape changes. But when value of this cell auto change (force from another software (kepware)), color of shape not change. Can you help me?
Thanks a lot!

Wow...This is a 4 year old post

Create a new post with an appropriate topic, and post the code as you have it currently to better your chances of getting help