I couldn't get the Number format to work if a number was
zero either.

But you could try the Conditional Formatting instead -
that works.

If you need to do teh format for a whole range, then
highlight the range before you select conditional
formatting.

HTH
-----Original Message-----
Hi,

Selection.NumberFormat = "[Green]#,##0_ ;[Blue]0,##0_;
[Red]-#,##0 "

I tried to make a numberformat which gives:

green when positive
blue when zero
red when negative

Help me, please!

Tnxs in advance


---
Message posted from http://www.ExcelForum.com/

.