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

G

greenfinger

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?
 
B

Bob Phillips

Use a custom format, along the lines of

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


--

HTH

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

pinmaster

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

HTH
J
 
G

greenfinger

Hi pinmaster

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