Hi All,

I want to format a crosstab with alternate row shading. I have used the formula below using the formula workshop in the background properties of the inner cell in the crosstab.    If I apply to a cross as in the second example below it works  However in the first example cross tab below I get a chessboard effect rather than alternate row shading.  I am guessing because there is only one value for each row element Crystal is working left to right for all the cells in the cross tab rather than just for the row value. 

Is it possible to do alternate row shading on a crosstab that only has 1 value.

TIA John 

numbervar x:= x + 1;

if remainder(x,2) = 0 then RGB(219,219,219) else RGB(240,240,240)

           day1  day2  day3  Total

hour1   1       2          3         6

hour2    1       2          3        6

hour3     1       2         3        6

Total       3      6         9        18 

            True   False   Total

Day 1     21       5         26

Day2       10      10       20

Total       31      15       46