Redlighting negative numbers not working

[mikersas]

Something missing?

ods tagsets.ExcelXP file='D:\Admin\CA_NIC.xml' style=printer;

ods tagsets.ExcelXP options(sheet_interval='bygroup' sheet_label='Distrct'

absolute_column_width = '6,10,11,11,25,10,25,6,6,6,30,25,11,11,11,11');

Title 'Current Quarter Assets vs. Previous Quarter';

Proc print data=Admin.Canicmerged noobs label split='*';

by lead_ofc_id;

var id_rssd;       

var    PctDiff    / Style={tagattr='format:0.00;[Red]\(0.00\)'};   

var    &qtr2    ;   

var    &qtr1    ;   

var    idrssd    ;   

var    supr_event_nr    ;

[Kurt_Bremser]

Have you tried running your code with and without the / Style option and compared the resulting xml files?

[data_null__]

Sometimes style overrides don't work and you have to create new style elements.

proc template;                                               
   define style styles.my_journal;                          
      parent=styles.journal;                                 
      style angle_header from header / tagattr = 'rotate:45';
      style red_data from data    / tagattr='format:0.00;[Red]\(0.00\)';
      end;                                                   
   run;             

data test;
   do x = -1 ,1,-2,1,-100000;
      output;
      end;
   run;
ods tagsets.excelxp file='~/red.xml' style=my_journal;
proc report nowd list;
   columns x;
   define x / display style(column)=red_data style(header)=angle_header 'Traffic Light';
   run;
ods tagsets.excelxp close;

  
   
                                                             

[mikersas]

Same result.  Is the number supposed to be stored by excel as text? Maybe I should change the format in the table.

[mikersas · Accepted solution]

The problem was that the field was formatted as NEGPAREN8.2 in the table.

As soon as I changed it to 8.2 and recreated the table - it worked.

Thanks all!