How do I display negative numbers in a differnt color font?

  • Thread starter Thread starter Guest
  • Start date Start date
set a custom format of say

#,##0.00;[Red](#,##0.00

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Hi
goto 'Format - Cells', choose 'Number' and choose one coloured option
 
Select the cells you want this to happen to.
Format | Cells,
Pick either Number or Currency.
Then, you can set one of the red options.

If you want a color other than red, try a Custom Format. Something like:
#,##0_);[Blue](#,##0)
would work.
You can experiment a little to figure out what colors are available to you.

tj
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Red cell for negative numbers in Excel 1
Excel 2007 Conditional Font Color How To? 1
Displaying negatives with (brackets) 3
Negative Numbers 8
display time variance in negative numbers 3
formatting negative numbers 1
A negative display watch 9
Coloring cells 8

Back
Top