Search results

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?