Hello,
I'd like to run a macro when a cell value changes conditionally, based on values entered into precedent cells (so that I'm not actually selecting or typing into the cell in focus) - is this possible? Ideally, I'd like to have a message box pop up, but could also insert a comment or autoshape. I can't find a way to get VBA to recognize such a change.
Thank you for your help!