excel custom number format coding

[Jon_P]

So I am trying to create a custom number format in Excel 2007
I would like all numbers greater than 0 to display red text, all numbers less than 0 to display yellow text and 0 to display green

I tried a couple different coding but i keeping getting an error code saying Excel cannot accept the number format

Any help would be awesome...

Thanks in advance
jon_p

[vandan_tanna]

Try:
[Red]General;[Yellow]General;[Green]General

first part is used for positive numbers, second for negatives, third for zero.

this should get the colors working for you. Next if needed, replace "General" with your desired number format.

Hope that helped.

[Jon_P]

this worked, i have to laugh becuase that was easy... ... of course i was attempting to make it harder then the solution..

thank you

[Jon_P]

Ok I am back, using the code given by vandan tanna [Red]General;[Yellow]General;[Green]General

how do i set the Decimal place to 0 example 405.4 would display 405 or 405.6 wold display 406

[vandan_tanna]

tRY:

[Red]0;[Yellow]0;[Green]0

[Jon_P]

thank you again...