Update cell Values or Read Values in other sheet (change colour of autoshape with VBA code

HI,

I am new to Excel VBA programming and assigned to Excel VBA support project to work to increase the performance of excel with VBA programming.
I want to make an Autoshape change colour with value in side.
<80% Red
>=80% to 100%< yellow
>100% green
And the code I'm using is

Please Login or Register  to view this content.

The code works but one has to click in the cell value and press enter for the colour to change, this happens because the value of cell A2 is =Home!A2.
Can you help me to make the code work directly from Home!A2 or make this code work so that I don't have to click in the cell value and enter.

Hello Winon,

Sorry but I can't upload file, because it has confidential data .
I had that idea but it was not accepted. They want to keep the autoshapes. (the WorkBook has more than 30 sheets and each one has the autoshapes).
I really need to make this via VBA

Thanks for your advice.