color in cross table

[Daniel Perboni]

How i can force a color based on cell value and other field using a cross table

I have date and day of week as headers , and i need :

 

if the "dayofweek" is saturday(6) or sunday(0) then

cell. color = yellow

else

if cell.value = "-" then // when there is no data the cell is empty or can be put a text in "Appearances"

color = red

else

color = white or without color

end

end

example in the file "example.zip"

Thanks.

[Shashank Gurnalkar]

As per my understanding, the condition that we put in the color rules in cross table is applicable for the cell values and not for the horizontal or vertical axes.