VBA Trouble

[121221]

Hi, I'm very new to VBA and I'm self teaching. I have a task to create a dashboard where the values (Within shapes) change colour based on value. Red,Yellow & green. I have managed to get this working with data on the same worksheet however when I try and use the data from another sheet the colour changing of the shapes stops working but the values show correctly, I even tried pulling the data from the other worksheet into the dashboard sheet and then using that cell to pull the data for the macro but still won't change colour only value? Any ideas please?

My second issue is when I use a cell for the Macro and change it to % the same issue as above happens, no colour change but value good???

Thanks

 

[GlennUK]

I'd day that'll have to show your macros before anyone is going to comment on this.