You can customize the rows by customizing the background color for each expression. This is done in two ways.
If you want the same color for all the rows, select the design mode, select any cell in the expression column, right click and select custom formal cells. You can chose the color that you want and you can apply changes to the current expression or all the expression (Selection is available in the dialog box).
You can do the same with the column headings.
If you want different colors for different rows, here is what you can do.
In the expression dialog box, expand any expression and select the background color. In the definiton, you can insert a function such as
The above will have two colors, white and gray for alternate rows.
My problem is similar.
In my rows I have all representatives with 2 rows (info current year and info last year)
Some representatives are new and do not have figures for last year, so only one row is shown.
I would like to switch colours when the representative is changing, not taking into account if the table shows one or two rows for each representative.
Any suggesions ?