Excel: how can cell contents be coloured if they are negative?
 

I have set up a spreadsheet for financial accounts and wish to highlight
results where the balance is less than zero. Is there a way of writing a
cell formula or another way of showing negaitve results in, say, a red colour
both on the screen and in print?

Excel: how can cell contents be coloured if they are negative?
 

--

HTH

RP
(remove nothere from the email address if mailing direct)


"greenfinger" wrote in message
...
I have set up a spreadsheet for financial accounts and wish to highlight
results where the balance is less than zero. Is there a way of writing a
cell formula or another way of showing negaitve results in, say, a red
colour
both on the screen and in print?

Excel: how can cell contents be coloured if they are negative?
 

Use a custom format, along the lines of

#,##0,[Red]-#.##0


--

HTH

RP
(remove nothere from the email address if mailing direct)


"greenfinger" wrote in message
...
I have set up a spreadsheet for financial accounts and wish to highlight
results where the balance is less than zero. Is there a way of writing a
cell formula or another way of showing negaitve results in, say, a red
colour
both on the screen and in print?

Excel: how can cell contents be coloured if they are negative?
 

Hi,
One way, in the format cell option select Currency as the "Catagory"
and in the "negetive numbers" select the red negetive numbers. Another
way is to use conditional formatting, Format/Conditional
Formatting....cell value is "less than" and type 0, then choose your
format.

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=490563

Excel: how can cell contents be coloured if they are negative?
 

Hi pinmaster

Many thanks - I am a new user so I had missed the obvious solution. Exactly
what I wanted.
greenfinger

"pinmaster" wrote:


Hi,
One way, in the format cell option select Currency as the "Catagory"
and in the "negetive numbers" select the red negetive numbers. Another
way is to use conditional formatting, Format/Conditional
Formatting....cell value is "less than" and type 0, then choose your
format.

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=490563