Font color for negative numbers
 

Help...I have created a spread sheet and I need to change the font color to
red on all the negarive numbers. I tried searching for but it doesnt' work.
Help ahain..thx

Font color for negative numbers
 

Select some of the cells that you wish to format this way, and from the Menu
Bar,
<Format <Cells <Number tab,
And click on "Custom",

Scroll down and you'll see several formats with RED in them.

Select one, and using that as a start sample, you should be able to get
something you like.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Regards" wrote in message
...
Help...I have created a spread sheet and I need to change the font color
to
red on all the negarive numbers. I tried searching for but it doesnt'
work.
Help ahain..thx

Font color for negative numbers
 

Did you look under FormatCellsNumberNumber "Negative Numbers"?


Gord Dibben MS Excel MVP

On Thu, 18 Oct 2007 17:40:01 -0700, Regards
wrote:

Help...I have created a spread sheet and I need to change the font color to
red on all the negarive numbers. I tried searching for but it doesnt' work.
Help ahain..thx