I have a 2 page spreadsheet. The first page called Debits, contains the cost of items that I have bought on ebay. The second page, called Credits, contains the costs of items that I have sold on ebay. On the second page I have a cell that calculates my overall balance (outgoings minus the credits). I would like to know if there is a formula that I can enter into this cell that would show the result in the colour red, if I've spent more than I've gained, and black if the opposite is true. At present, I manually chage the colour of the text. Can it be done? Thanks in advance.
The alternative is to select the cell, Format > Conditional Formatting. The left box should say 'Cell value is'; in the next box choose 'Less than' and in the third box enter 0. Click the Format button, change the colour to red and then OK your way out.