Conditional Formatting not working in Excel
Hi
I am trying to display the background color for the whole row conditionally, the syntax I am using is;
<?if@row:TRANSACTION_TYPE='INVOICE'?><?attribute@incontext:background-color;'Yellow'?><?end if?>
This works perfectly fine in PDF output but does not work in Excel. However if I restrict the formatting to one cell instead of the whole row, it works in excel as well. How do I do this for the entire row in excel?
Thanks in advance
Navaneeth
I am trying to display the background color for the whole row conditionally, the syntax I am using is;
<?if@row:TRANSACTION_TYPE='INVOICE'?><?attribute@incontext:background-color;'Yellow'?><?end if?>
This works perfectly fine in PDF output but does not work in Excel. However if I restrict the formatting to one cell instead of the whole row, it works in excel as well. How do I do this for the entire row in excel?
Thanks in advance
Navaneeth
0