How to evoke a macro from a cell condition?
I would like to run a macro automatically bqased upon a change in a
particular cell's condition. As an example:
Cell A1 contains the following formula: =if(b2b4,"Sell",0)
If A1 = "Sell", I would like to automatically run a macro. Is this possible?
If not, can I automatically run a macro from a formula?
Any help will be greatly appreciated.
Paul
|