When a custom background color (heat map) is created for an expression in a pivot table the background color for the first row of data is duplicated for the expression header. This does not seem right, is there a way to hide the header row for the expression. I have 2 expressions for the pivot and it is adding the header row for both and there is nothing in the presentation tab that will allow me to suppress the headers and/or not create a background color for these.
If you use "Visual Cues" for the expressions and try to make your background color (heat map) in the "Normal" / Background definition, then the color is not duplicated in the expression header.
If you want to define a color for the header itself, you can use the "Text" / Background definition.
That's a good solution but is only works if you want to evaluate the same expression in "Expression" tab and in "Visual Cues" tab. If you need to vary expression line color by comparing other fields' values, "Visual Cues" doesn't do the trick.
I thnk that you can change the color of the header by doing waht HTH says using calculated color, and inside this option you can use different ifs to set the different colors. I have not tried this solution but I think it is going to work.
