Straight table Color Change

[sona_sa]

Hi,

I Have a sheet. There is multibox and a sraight table. I what whatever field selection is done in that particular multibox, That dimension font color or Back ground color should to be changed in that straight table.

At a time there is only one selection always will be done.

For ref. please check out attached jpeg.

Thanks

[jonathandienst]

Hi

Do you mean that you want to highlight a column in the table when that column is selected in the listbox?

You can place an colour expression for the background colour or font colour for each chart expression that checks the selected value and changes the colour accordingly. Something like:

For postal code:

=If([Column Name] = 'Postal Code', LightRed())

For fill date:

=If([Column Name] = 'Fill Date', LightRed())

etc

For a more comprehensive solution, I suggest that you upload a sample of your model.

Regards

Jonathan

[#3]

Go expression>select Background colour and try below scripts..

pick(match([Column Name], 'POSTAL_CD'),

rgb(255,0,0))

regards-bika

[sona_sa]

Can u use the same in the attached QVW file.

Thanks for Reply.

[sona_sa]

Please find the attached QVW for the same.

Thanks.

[#6]

Pls try to use pivot table..

find it attached

[sona_sa]

Hi Thanks for reply.

According to the solution.... I need whatever I will select in Multibox, That particular colomn color should to change. If Select POSTAL_CD in Multibox the straight table color should to change and If state_cd then State_cd column color.

[sona_sa]

Hi Thanks for reply.

According to the solution.... I need whatever I will select in Multibox, That particular colomn color should to change. If Select POSTAL_CD in Multibox the straight table color should to change and If state_cd then State_cd column color.

[#9]

Just i am manually fixed the column heading colour. no condition