can the negative numbers in an IF statement be in a diff color th.

[mwhite17@hotmail.com]

can the numbers in an IF statement be automatically programmed to change
colors when number is negative(red for negative and blue for positive)

[Peo Sjoblom]

Use custom format in the cell with the if statement and a format like

0.00;[Red]0.00

or use format>conditional formatting


Regards,

Peo Sjoblom

"mwhite17@hotmail.com" wrote:

> can the numbers in an IF statement be automatically programmed to change
> colors when number is negative(red for negative and blue for positive)