Skip to Content
0
Nov 29, 2017 at 07:24 AM

CR 2013: Coloring a whole row in the crosstab.

72 Views Last edit May 08, 2018 at 06:15 AM 2 rev

I have a crosstab that looks like the picture below

I have been unsuccessfully trying to color weekend days (which have suppressed data) for a while now, i am facing two problems:

1- if i color from the Crosstab format tab (Background color) i am unable to pass values such as if day = saturday/sunady then crcolor, the condition always goes to the else directly.


2- if i color each cell separately i am unable to color suppressed cells, they stay white because they are suppressed anyway.

Kindly assist.

Ashraf,