I know that I can run a macro by clicking a button and/or run the macro automatically once you open the xls file. However, I want to know

(1) how I can run the macro in a cell when it meet a specific condition. For example IF $C2 = 5, run macro 1, “ “ .

(2) I have a shape in a cell where a macro will be executed if the user clicked it. How can I make this shape active only if meet specific criterion?
For example, IF $B1 = 3, shape1=active, shape1=not active .

I appreciate your help. Thank you.