Number colours

[The Stoat]

Hi,

Is it possible to change to colour of a number to indicate whether it was
positive or negative? IE - blue for positive numbers and red for negative.

Thanks for any help.

Matt.

 

[Gord Dibben]

Matt

Format>Cells>Number>Custom

[Blue]#,##0.00;[Red]-#,##0.00

Gord Dibben Excel MVP

 

[The Stoat]

Thanks!

Matt

Format>Cells>Number>Custom

[Blue]#,##0.00;[Red]-#,##0.00

Gord Dibben Excel MVP

Hi,

Is it possible to change to colour of a number to indicate whether it was
positive or negative? IE - blue for positive numbers and red for negative.

Thanks for any help.

Matt.

 

[Gord Dibben]

Ray

Format>Conditional Formatting>Cell Value is: equal to 0

Format>Either font color or pattern color to Red.

Gord

Gord,

If the number = 0 and I want to make the "0" red, how would that be done?
For example, my formula is =COUNTIF(Schedule!D886,"*IV 1230*") and if the
answer is "0", I would like it to be a red "0". Thanks.

Ray

Matt

Format>Cells>Number>Custom

[Blue]#,##0.00;[Red]-#,##0.00

Gord Dibben Excel MVP

Hi,

Is it possible to change to colour of a number to indicate whether it was
positive or negative? IE - blue for positive numbers and red for negative.

Thanks for any help.

Matt.