how to add +/- and color to cells automatically

[ammartino44]

Hello. How can I format for a + or - for positive negative numbers and also have positive numbers be green and negative numbers be red? Danks.

[stephenloky]

Hello. How can I format for a + or - for positive negative numbers and also have positive numbers be green and negative numbers be red? Danks.

Hey you can do that with conditional formatting, do you have a sample worksheet so I can modify and explain you how? and a expected result for that worksheet?

[Richard Buttrey]

Hi,

Use

"+"0;"-"0

as a normal format for the cell and use one conditional format to format values <0 as red and another cond. format to format values > 0 as green.