What if Formula

Hi, is there a what if formula that will make the numbers in a cell red if the number is negative? And if the number is positive it will be green?

Sorry, yeah I meant conditional formatting. What would the needed language be within conditional formatting to achieve this?

Like this ?

You can also use cell formatting to achieve this.. add this in custom formatting: [Green]+0;[Red]-0;0

Originally Posted by josephteh

You can also use cell formatting to achieve this.. add this in custom formatting: [Green]+0;[Red]-0;0

Vote this solution