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

--
Thanks.

Steve

set a custom format of say

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

--

HTH

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


"Steve" wrote in message
...

--
Thanks.

Steve

Hi
goto 'Format - Cells', choose 'Number' and choose one coloured option

--
Regards
Frank Kabel
Frankfurt, Germany
"Steve" schrieb im Newsbeitrag
...

--
Thanks.

Steve

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

"Steve" wrote:


--
Thanks.

Steve