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

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

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

0.00;[Red]0.00

or use formatconditional formatting


Regards,

Peo Sjoblom

" 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)