Can you please give me the formula to show positive figures in black and negative
figures in brackets?
Also to show positive figures in blue and negative figures in red (not in brackets).
Thank you,
Barry

Hi Barry,

Thanks for the question.

There are a couple of things you could do. First select the figures you want to apply the formatting to and go into the Format>Cells>Number and tick the option that deals with red negative numbers.

Secondly you could apply a conditional format to your numbers this is where you can apply a specific format if the numbers meet a certain condition. To do this go to Format (menu) and down to Conditional Format. You could put if "Cell Value" is less than 0 .... then change the format by using the format buttin.

Hope this helps

Tracy