View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Frank[_28_] Frank[_28_] is offline
external usenet poster
 
Posts: 14
Default In Excel 2007, color for number format axis not working

..Axes(xlCategory).TickLabels.NumberFormat = "+0.00%;[Red]-0.00%;
[Blue]0.00%"

It works in Excel 2003 but in 2007, the colors don't make it (the rest
does).

If I tried manually, it does not work either

I've googled around but not to avail.

Any ideas?