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.

You need to have a cell (say Z1) which will have the current value of A1
(which does not change) so that when A1 changes it can be compared to the old
value...
You can highlight by conditional formatting, using FORMULA IS...
=A1<Z1
You will then have to find a way to copy the new value in A1 to Z1...


"Highbury 1" wrote:

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.