topic Re: Change color for active sheet in QlikView

Change color for active sheet

chadliagabsi — Fri, 12 Jan 2018 13:52:40 GMT

Hello !

how can i force a color for an active sheet.

Thanks

Anil_Babu_Samineni — Fri, 12 Jan 2018 14:04:24 GMT

May be, Condition for Sheet Properties like below =If(SubField(GetActiveSheetId(), '\', 2)='SH02', Green())

Peter_Cammaert — Fri, 12 Jan 2018 14:19:31 GMT

That was just for changing the tab color of the Active Sheet.

If you want to change the background color as well, use the same expression in the Sheet Properties->Background->Sheet settings->Color button:

Then, to mirror this color in the Tab, select "Sheet Background" in the Tab Settings.