I want to create a large workbook tracking my finances, I've pretty much had enough of MS Money. I want it to be pretty much selfupdating etc after I have inputted amounts/numbers.
To start me off, does anyone know a formulae so that if I enter a column of data and I want to reference it, I can get Excel to look down that column and pick the last entry? (to display it in another worksheet)
Secondly using this data, after finding it in the column how can I display it on say another worksheet and then ask it to change the colour/font of the displayed text (on this other worksheet). I.e. red (and bold) if the amount is less than £0 and black if it is more than or equal to £0.
Help would be much appreciated, with the formulae displayed or some hints. I will no doubt want to do more a bit later one, but just want the basics working at the moment
Cheers
Ian


LinkBack URL
About LinkBacks

Reply With Quote



