Alternating colours in cross tab report

[Ofina]

I want to alternate colours in my cross tab.

I have found this thread:
thread149-1166557

But, it doesn't quite do what I want.
First of all, how can I make it grey instead of yellow?
Second of all, I have suppressed zeros, but this messes up the colouring. It only works if the zeros are left in.
Third of all, the summary colouring is one row off from the label colouring. They are alternating on the odds as opposed to the evens.

 

[IanWaterman]

The formula toggles from yellow to white by just changing the Blue of the RGB

To toggle from grey to white

is more complex
Try

whileprintingrecords;
numbervar d;
d := iif(d=255,50,255);
if d = 50 then color(50, 50, 50) else color(255,255,255);

Ian

 

[Ofina]

I wound up using

whileprintingrecords;
numbervar c;
c := iif(c =255,211,255);
color(c,c,c)

Still having a problem with the zeros and the alternating being one off on the row labels.
Have decided that no zeros and no shading is preferable to shading and zeros. Would prefer shading and no zeros though.