Change Autoshape Color in one worksheet based on cell value in a different worksheet

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

Hi Vigny and welcome to the forum.

You can reference other sheets from the Change Event macro using Sheets("SheetName"). The change event should be in the sheet with the percentage on it.

Alternatively, if you can use WingDings instead of an autoshape, you would be able to use Conditional Formatting. You will need to use named ranges to achieve this. So, create a named range, e.g. MyPercentage, referencing the cell with the percentage in it. Swap to the other sheet and use that name in your formula for creating conditional formatting.

If this doesn't answer your question, can you upload a copy of the worksheet? To do this, press Go Advanced below then Manage Attachments.

Best regards, Rob.