microsoft excel courses - Excell - Financials

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