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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Program buttons to create a word document 0
SUMIF with broken range 10
Reverse color numeric formatting? 2
Page numbering with Merged Document and IF statements 1
Linking Equations to Highlights 2
can the negative numbers in an IF statement be in a diff color th. 1
How to change numbers from positive to negative. 2
Change positive to negative number 3

Top