Skip to Content
Nov 29, 2017 at 07:47 AM

CR 2013: Coloring crosstab background on specific rows.

67 Views Last edit May 08, 2018 at 06:12 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.