I have a worksheet with a formula that returns a value in cell A1. The
worksheet is set to auto calculate. I want to find a function that will
trigger a return of either a True / False or 1 / 0 whenever the value in cell
A1 updates.

Any ideas would be great,

Thanks.