Matrix Group Shading

I am using SQL 2000 Reporting Services.
I am trying to get a column group to shade if it starts with the word
Total. The problem is there is not always a "Total" value for a
particular "row group" (date). Is there a way to shade the entire
column?
Here is the current formula. Is there a way to reference the current
group header?
=iif (mid(Fields!SubType.Value,1,5)="Total","PaleGoldenrod","")
Thanks,Basically I want to set the background color on the entire column if
the group (column) header begins with the word "Total".
daveg.01@.gmail.com wrote:
> I am using SQL 2000 Reporting Services.
> I am trying to get a column group to shade if it starts with the word
> Total. The problem is there is not always a "Total" value for a
> particular "row group" (date). Is there a way to shade the entire
> column?
> Here is the current formula. Is there a way to reference the current
> group header?
> =iif (mid(Fields!SubType.Value,1,5)="Total","PaleGoldenrod","")
> Thanks,