Shape Color Change Based on Value in different sheet

Hello All! I've been hunting around for a solution and can't find exactly what I need. Any help on this would be greatly appreciated.

I'm trying to change the fill color of a shape based on the value of a cell. I've achieved this by using a Worksheet_Change Event, but when the referenced Rang Cell contains a formula linking it to another sheet (=sheet2!E2) it no longer works.

Please Login or Register  to view this content.

My Source will need to come from a different Sheet, and cannot be on the same sheet as the shape. Thanks!

Hi Kevin,

Try putting the same code inside:

Please Login or Register  to view this content.

Please let us know if there any unwanted side effects.

Lewis