How can I change the background colour of an object when the sheet is active?

[Anonymous]

I have disabled the tabrows and used text objects (with actions) to move between the sheets.  I would like the background colour of the objects to change when each sheet is active, as a visual indicator to the user. Please can someone offer help in a very basic and non technical way?

Thanks

[MK_QSL]

Check enclosed file...

[pradnyat]

Hi Simon,

Suppose your sheet ID id is 'SH01'

Then in text box background color, write calculated expression as

=if(getActivesheetID()='SH01',Black(),white()).

Hope this will help you.

[MK_QSL]

It should be...

something like below...

=IF(Wildmatch(GetActiveSheetId(),'*SH01*'),QlikTechGray(),Blue())

[Anonymous]

That has worked.

thanks very much for the help

[MK_QSL]

Kindly close the thread by selecting appropriate answer...