Excel 2007 quick question

Andybtsn · 29 Dec 2008 at 00:23

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

Ben643 · 29 Dec 2008 at 00:30

Umm... I'm not entirely sure if this is what you want... but I think this should help: http://www.homeandlearn.co.uk/excel2007/excel2007s6p2.html

It's called "Conditional Formatting" if you're trying to do what I think you are.

Andybtsn · 29 Dec 2008 at 00:32

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?

oddjob62 · 29 Dec 2008 at 00:43

Just tried on mine and it works fine.
Are you sure you're not copying/cutting and pasting a value to that cell and in doing so cutting and pasting the cell format?

Andybtsn · 29 Dec 2008 at 00:45

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 · 29 Dec 2008 at 00:47

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...

Nanobot · 29 Dec 2008 at 20:36

I would ignore the preset rules and create a new rule.
Highlight your data area and create a new conditional formatting rule.
New rule > Format only cells that contain
Set your criteria below it > Cell value less than 0
Format button and set your colour to red

Works regardless of the table layout format you mentioned above.