I have a formula in cell B1 that is linked to several other cells. If
various condidtions are met, the value in cell B1 will equal, "Yes".
Otherwise, it equals, "No".

Is there a way I can trigger a macro anytime the value in Cell B1 changes
from "No" to "Yes". I would like for a message box to pop-up with a warning.



--
Thanks
Shawn