Crosstab - colouring columns dependet on value in column header 1

[Tstegen]

I have a crosstab showing amount per pay element for each employee.
Rows: Employee
Columns: Pay element number
Sumarized fields: Amount


I would like to colour the columns dependent on the pay element number in the column header.

I have used this code in amount ->right click->format field->borders->color->background->x+2 and enter, but the result is yellow columns for all amounts for pay elements.

whileprintingrecords;
numbervar a:={Command.PAY_ELEMENT_NO};
if a = 100 then crYellow else crNoColor

Command.PAY_ELEMENT_NO is the column header field.

Any tips or help is appreciated.

 

[lbass]

Use a formula like this:

if gridrowcolumnvalue("Command.PAY_ELEMENT_NO") = 100 then
cryellow else
crnocolor

-LB