This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am trying to conditional format by column via the Table Tool. Below is an example of the column with the equation. Upon running, i receive an output/error. Can you please let me know where i am going wrong, thanks.
IF [Total Remaining Hours]<= 0 THEN "color: green;" ELSE "color: red;" EndIF
Negative = Red, Positive = Green
Output Data (1789) Max character width supported by Excel for a single cell exceeded, 47831 characters were truncated. fieldname: Table record number: 2
Thank you for the solutions, they both worked. However i am still getting an error while outputting to a regular Xlsx format (Output Tool). Does the table tool only output correctly via the Render tool? If so is there a way to adjust column width to "autofit" column width? Please let me know, thanks again.
Ah yes you'll have to use the render tool to output with the reporting tools. As far as I know there is not way to autofit the columns, although you can play with the paper size/margins in order to get it as close as possible. I think the reporting tools actually make it a little easier in that regard as opposed to the regular output tool where adjusting column size is definitely not an option.