Conditional Formatting using a separate document for multiple conditions

[pmelnick]

I have a chart field (pivot table) that needs conditional background coloring according to multiple criteria. The conditions are in an excel file that will be periodically updated. Fields in the excel sheet are Warehouse and Stops and they are linked to the Orders table via the warehouse number.

We need to add color to fields based on the following:

if warehouse# in the chart is equal to the warehouse# in the excel file and the # of stops on the chart is greater than or equal to the stops in the excel file, color the field red, otherwise keep it white. I see there are two places this can be done (expressions and Visual Cues) but have not had luck with either.

Help with code and where the best place to put it will be appreciated!

[Anonymous]

Assuming that warehouse# is a dimension in your table, the right place to assign background color is the attribute expression "Background Color". You see it if expand the "+"-sign to the left of the expression name. The expression for the color will be something like this:
if("expression that calculates number of stops in QV">="number of stops from Excel", rgb(255,0,0))