I have a fully functioning Stockmarket trading log, in Excel, where I record the trades I have taken and various sums are performed on them. I need a few amendments, preferably without using VB which seems to slow down my system significantly: 1) The value in R1008 can't be calculated because some cells are Null. So those cells need their formula amending so that they are never null OR r1008 needs to ignore any null values 2) Conditional Formatting rules need adding so that the text of column Q is coloured white if the cell is empty 3) Column F automatically generates a default value for column G, which in turn generates values for P & E. But sometimes the user will want to over-ride the default value of G by typing another value in. In that case, F should be calculated according to the value of G.
1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Employer will receive exclusive and complete copyrights to all work purchased. (No 3rd party components unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's Worker Legal Agreement).
Excel 2003, 2007 & 2010