Looking for a solution to my Macro button (shape) problem.
I have the below code which will colour a depressed button.
Problem is this will only work for 1 button and i have 12 that i want it to work for.
The idea would be that the button stays depressed until another button is selected...
I want to do dynamic the shape color based on cell value (percentages) where:
Value (%) > 0 [Green]
Value (%) < 0 [Red]
I could do it with the following VBA code (thanks to Extendoffice page) but JUST FOR ONE SHAPE:
Private Sub Worksheet_Change(ByVal Target As Range)