Jump to content

color in cross table

Daniel Perboni

Recommended Posts

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


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

color = red


color = white or without color



example in the file "example.zip"


Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...