Cell values have changed

  • Thread starter Thread starter Highbury 1
  • Start date Start date
H

Highbury 1

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formula, sum the value cell and if empty cell left blank 0
Function to put worksheet name in cell returns text, need number 5
Excel VBA 1
Excel Need Countifs Formula Help 0
Code to format cells on several worksheets 2
OR formula, ????? 2
problems getting this macro to work 23
Use cell contents to build sheet reference 5

Back
Top