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)