Change Background Color

[tedew1]

hello

Now I have a problem with changing Color of the Column . Not all Column but only one.

bye

 

[lbass]

I believe you are working with a crosstab. Right click on your column label->format->border->color->background->x+2 and enter:

if currentfieldvalue = "Yourcolumnlabel" then crYellow else crNoColor

For the inner cells or totals, use a formula like:

if gridrowcolumnvalue("table.columnfield") = "Yourcolumnlabel" then crYellow else crNoColor

In the last formula, you would remove the curly brackets from the column field and replace them with ". If your column field is {Sales.Country}, then "Sales.Country" belongs in gridrowcolumnvalue(), while the name of the country would replace "Yourcolumnlabel".

-LB

 

[tedew1]

hello
thanks for your help

when I put your Example to the "x+2" I get error
"This function can only be used in field formatting formulas"

if gridrowcolumnvalue("Command.Data") = "Total" then crYellow else crRed

bye,

 

[lbass]

You need to right click on the cell->format field->border->color->background->x+2 and enter the formula there.

-LB