Excel Numberformat

[koettermann]

Hi,
I want to change the Color of Numberformat in Excel.

I tried
chWorksheet:Range('C6:H20'):NumberFormat = '#.##0;[Red] -#.##0':U .
It does not work.

without [Red] it works.
chWorksheet:Range('C6:H20'):NumberFormat = '#.##0;-#.##0':U .

What must i do to change the color?

 

[joey.jeremiah]

as always, when in doubt with office
turn on macro capture
and take a look at the vb code generated

give this a try, it worked for me

chworksheet:range("C6:H20"):font:colorindex = 3.

joey jeremiah, degrassi

 

[Casper]

In what language is Excel installed?
We have a dutch installation of Excel and there
h-ws:ActiveSheet:Columns(ENTRY(i_tel,cp_number)):NUMBERFORMAT =
'#.###.##0,00;[Rood]-#.###.##0,00' works fine.
(Note Rood instead of Red )

casper.