Font color for negative numbers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Regards - 19 Oct 2007 01:40 GMT

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

Reply to this Message

RagDyer - 19 Oct 2007 01:47 GMT

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.

Signature

HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

> 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

Reply to this Message

Gord Dibben - 19 Oct 2007 01:58 GMT

Did you look under Format>Cells>Number>Number "Negative Numbers"?

Gord Dibben MS Excel MVP

>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

Reply to this Message

Rate this thread: