know all to do all the calculations, but how do i do it for the entire column so i dont have to copy individual cells and pasting it each time to transfer the formula? is there anyway to just set it by column so each time i type in a new trade it just calculates it by itself....
also, is there a way to do it so that if let's say my trade was profitable, it automatically makes the profit cell for that trade green? like the one in this picture? and maybe red for a negative trade?
===========
There are several ways to replicate the cell formula.
1. Copy the cell. Select the range of cells where you want the formula to go and select Paste. Formulas will automatically adjust for the row number. Or,
2. You can also use the Fill command from the edit menu. Or,
3. Click on the cell. Put the cursor on the lower right corner where it will turn into a plus sign. Click and drag down the column as far as you want to replicate the cell.
You can also do these with a range of cells. If your formulas are in D5 to H5, then select cells D5 to H5 and do either 1, 2, or 3.
Font Color:
Sophisticated: You can format the cell color by going to the Format menu and selecting cells and creating a custom format with green for positive numbers and red for negative numbers.
Simple: Just select a standard format that automatically colors negative numbers red. Then set the desired cells to a font color of green. Non-negative numbers will then be green and negative numbers will automatically switch to red.
