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

M

mwhite17

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

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
 
Top