I am not sure if you need entire column to change color based on the total, or a single table cell. If the color depends on the field value only, you can use conditional styling. If your colors depends on the column total (and not the field value), then you may try to do following: 1. create overlay of 2 text fields with value of empty string, use background color to highlight; place those fields underneath your actual field which should be transparent 2. create a variable to track column total, then use that variable as condition to show / hide the fields from the previous step 3. evaluation time of the colored fields should be set to after the variable evaluation time in order to use it in the show / hide condition If the output is into Excel file, check for the excel-safe color palette.