Syrus,

Try this

"_-[Green]#,##0_-;_-[Blue]#,##0_-;_-[Red]-#,##0_-"

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Syrus the Virus " wrote in
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/