I need to change the color of an autoshape in one worksheet based on the cell value in a different worksheet.
The Worksheet Change event seems to work only when both the cell and the shape are in the same worksheet.
The cell contains a formula that calculates the percentage based on input numbers, I need the autoshape to show
red when percentage <=25,
yellow when % > 25 and % <= 50
blue when % > 50 and % <= 75
and green when % > 75