I need help! I'm doing something and I am using shapes in Excel. I want my shape to automatically change color based on cell value in another sheet. I've used a VBA code before, however, the function only works if you are changing the value of the cell in the same worksheet. I need a code that will automatically change the color of my shape when I input a value in a cell in the other sheet.
Hoping for your help.