Hi All,
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.
Equation:
IF [Total Remaining Hours]<= 0 THEN "color: green;" ELSE "color: red;" EndIF
Negative = Red, Positive = Green
Output Error:
Output Data (1789) Max character width supported by Excel for a single cell exceeded, 47831 characters were truncated. fieldname: Table record number: 2
Data:
Total Remaining Hours
335.5 |
632 |
301 |
41.75 |
-547 |
1288.5 |
510 |
707.75 |
28 |
Solved! Go to Solution.
Hi @AustinRiggs94,
I'm not sure how you were getting that error, but try using what I came up with in the attached workflow. I was able to get the conditional formatting by introducing two row rules.
Best,
mmenth
The equation you listed, are you entering that into the Formula field of the Column Styling Rules? That formula is only to return a true/false value for the application of each rule.
I suggest you create two column rules: one for red, one for green.
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.