 You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
I am setting up an indicator to test some limits on an excel sheet. Basically A1 contains a number between 1 and 100 and changes due to external data, B1 needs to be set with red text between 0 and 100. When A1 reaches 100 then B1 should be normal text, and C1 should be red text until A1 gets to zero again, the process will then repeat. B1, and C1 are indicating wether A1 is increasing or decreasing. A1 will never reverse direction until it reaches its limits. I realise this is probably fairly straight forward for a programmer to do with vba but I would rather not use any code if possible.
Thanks in advance...
For all Excel related questions I use mrexcel . com there are loads of IT bods on there who have always managed to resolve my excel macros / formula problems
good luck
you need a historic record of A1 in order to monitor changes over time. A formula wont "remember" a previous value once it's been changed.
You'd need to have your external data populate two columns one for t0 and one for t-1.
Thanks for your replies. Still not sure how to implement that solution Stoner. I wanted to make this work while I am setting it up in the office, so the cells to highlight and the data would just be simulated, the real external data is not available to me here.
how does the data update?
do you open the file and a dynamic link updates the data in cell A1?
is that the only data cell?