Excel 2007 quick question

[Andybtsn]

Hi guys,

I have created an excel spreadsheet that has various currency figures on it, I have set the cell format to be Currency, then -1234,10

So when I input a figure, say -90 does it not change the colour to red?

The spreadsheet shows credits and debits so need debits to change colour.

How do I sort this?

Thanks

 

[Andybtsn]

I just need the font to change in colour (red) when I put a minus in front of a number.

I think the link tells you how to make a cell change colour?

 

[Andybtsn]

Nope, I go to the format cell change it to the Currency setting then type in a figure but it just has the font colour as blue, it adds the £ though

 

[Andybtsn]

Hmm, just tried it on a complete new spreadsheet and it works.

I chose a "Format as table" layout, could this be why I'm having problems inputting on it?

Seems a bit odd...