Macro to highlight the first column in a table?

[#1]

Hi All,

I have searched for a solution for this and found some, but doesnt seem to work. I have a search box, where I search for a manager and then select him, in the main chart i see, institution_tag (Clients List of this manager), I want the first column highlighted and so the rest of the charts on the same page shows all the relevant information of this client only.

Can this be achieved using QV9 SR5 Actions or do i need a macro for this.. someone suggested it should be a macro which I am not comfortable working with...

Thanks Again,
Red

[#2]

Create a Variable, fill this variable with a trigger on change of Manager

Bases on this variable you van fill the backgroundcolor of the column

[#3]

Hello Jochem,

Thank you for the quick reply, I am kind of new to QV so can you please take some more time to explain this in a bit detail of how to do it... I currently have a variable $(vColorInstitution) Which I use to highlight a column, but this has to be done manually by the end users. For working now, Can I have the first column of the chart to be highlighted as soon as I search for a manager with this variable, or do i need a macro..? If I can use this variable, then how...?

Red

[#4]

in settings-document there is a tab triggers

put a trigger on the manager field and fill the variable on selection

if you select a manager the variable will be filled and the column gets the variable color