Number colours

  • Thread starter Thread starter The Stoat
  • Start date Start date
T

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.
 
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.
Click to expand...
Click to expand...
 
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!D8:D86,"*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.
Click to expand...
Click to expand...
 
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!D8:D86,"*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.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top