Custom number format with colors

[andre.labonte]

Hi,

I would like to format my numbers this way:

0 --> Green

= 0 --> Black
< 0 --> Red

How can I do that?

Thanks!!

 

[Guest]

Go to Format->Conditional Formatting... set your specs and click the format
button to format the text the way you want. You will do a seperate one for
each color. Select the entire sheet first though (CTL-A)

 

[JE McGimpsey]

One way:

Format/Cells/Number/Custom....

[Green]General;[Red]General;General;@

 

[JE McGimpsey]

That will certainly work, but is somewhat more resource intensive than
using Custom Formatting.

 

[Bob I]

Conditional Formatting.

Hi,

I would like to format my numbers this way:



= 0 --> Black
< 0 --> Red

How can I do that?

Thanks!!