04-03-2017 06:43 AM
I want to create an xml file in SAS (9.4), and I want it to include conditional formatting, so when you change a cell value in that xml file, that cell eg changes colour. I.e. I don’t want to define the cell value in SAS, but in Excel (2016). Is this possible? If so, how?
04-03-2017 09:33 AM
04-04-2017 04:24 AM
04-04-2017 09:23 AM - edited 04-04-2017 09:25 AM
it's really odd, but when I look at your sheet, the value of A1 is red and the value of B1 never changes color when I change the value in A1.
Looking at the Excel file itself, it appears that the formula specifies to change A1, not B1.
However, the question for Tech Support will be whether ODS EXCEL (the only destination that creates XLSX files) can insert the necessary XML into the XLSX zip archive, as shown below.