I have a cross tab similar to the following example. The field in my header is {alphabet} and alphabet includes A,B,C and D. The {count}values in my crosstab are 2,10,20 and 15 respectivly for A,B,C and D.

A   B   C   D
2   10 20 15

I would like to be able to format the {count}values in my crosstab based on the value itself (which i know how to do) but also on the value of the {alphabet} header.

For example if {alphabet}="A" and gridvalue<10 color equals red. and if {alphabet}="B" and gridvalue<5 color equals blue.

I know how to set the colors based on the gridvalue. I am not sure how to appropriately reference the value of the crosstab header {alphabet} and make the formatting based on the two values.

Thanks in advance for any insight.

CJB

Thanks i will investigate your suggestions.