Is there a way to conditionally colour in a row in a TableBox?
For example, if I have a column with a 1, 2 or 3 in it, can I write an expression to set the colour of the row with a 1 to red, the colour of a row with 2 to blue and the colour of a row with 3 to yellow?
I've created an expression on my tablebox called M_Seconds which contains a calculated number of seconds. It's set to 'hidden' in the presentation tab. How should I colour in one or more cells based on this expression?
For example, on the Presentation tab I picked one of the columns, selected 'Conditional' and then entered this expression:
expecting this to change the background color of the cell to red but it didn't do anything.
You can use either the Style tab in the object properties, and set it to Pyjama-something that will display automatically one line in one color and the next in a different one, or enable the Design Grid in the View menu, and right click on the table box selecting "Custom Format Cell" and setting a conditional color.
Another option is to use a Pivot table instead of a table box, so you can use the dimension and expression formats as mentioned above.