Thread: Numberformat
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Syrus the Virus[_13_] Syrus the Virus[_13_] is offline
external usenet poster
 
Posts: 1
Default Numberformat

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 advanc

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