Background color

[#1]

Hello,

I have a column in a table that I give green or red background depending on a value, it looks like this:

if(((avg(trim(Nivå))=32 or avg(left(Nivå,2))=30) and [Förändring %]>0) or (avg(trim(Nivå))<>32 and avg(left(Nivå,2))<>30 and [Förändring %]<0),rgb(210,112,89),
 if((avg(trim(Nivå))<>32 and avg(left(Nivå,2))<>30 and [Förändring %]>0) or ((avg(trim(Nivå))=32 or avg(left(Nivå,2))=30) and [Förändring %]<0),rgb(88,178,13)))

But with this script I also get the header of the column in this color, I want to keep that one white, how do I do that?

[#2]

Are you using QV 8.5 or 9?

Because if I set background color to "RGB(x,x,x)", all rows except header are painted in this color. I am using 8.5v.

[prieper]

You may include RowNo() = 0 in your condition and assign another colour to the header-row

HTH
Peter

[#4]

Hi Per,

I have the same problem, did you find a solution to this yet?

Thanks, Lukas

[michael_anthony]

Problem only appears on Pivot Tables, straight tables are okay. I've tried various methods such as RowNo, Dimensionality functions without success. Also tried Custom Formatting cells, again without luck.

I tried to use a macro, but couldn't get to work, although may be possible.

Searches I've previously done on forums all say same problem - appears that QV just does it that way and not much can be done.

[#6]

Ok, so it's just another of these little weird things in QV. Thanks for your response.