Change colours in Tabrow

[Anonymous]

Hi,

How did they add variables vTab1_On, vTab2_On, vTab3_On, vTab4_On, vTab0_On to change a colours for Tabrow?

Please find attached file.

Thanks,

[mikecrengland]

On the General tab of Sheet Properties. (bottom right)

[Anonymous]

Thanks,

But there is a condition.

Regards,

[regowins]

The vTab variables were added in the variable overview under settings menu.

[stevedark]

As I think you have spotted already, the Calculated Colour code is important, and then the variables to say which tab is active are set by triggers.  These are set on the Triggers tab of the Sheet Properties.  On entering a tab the appropriate vTab variable is set to 1, on leaving it is set to 0.

The vTab variable is then used in the Conditional Colour expression.

If I were going for the same effect I would probably go for:

=if(GetActiveSheetId() = 'Document\SH04', rgb(255,79,79), rgb(255,255,255))

To avoid the use of triggers, but the way it has been done in the document you attached works fine too.

Hope that helps.

- Steve

[Anonymous]

Hi Steve,

I added variables vTab1_on=1, other variables =0.

I added conditions for each tabrow, but my variables didn't change dynamically.

Maybe you know how set dynamically variables.

Thanks,

[stevedark]

Just right click on a blank area of the sheet and right click and select Properties. Select the Triggers tab and create the required triggers. See the fast food example for details.

Or, use the example I posted above that doesn't require variables and triggers....

[Anonymous]

I know this.

I don't know how to add variables which changed from 1 to 0, if selected a tabrow.

I saw in the example conditions and variables vTab_on changed from 0 to 1 indepent of current tabrow.

How to make changed variables?

Thanks,

[regowins · Accepted solution]

For example, if I  do sheet 6 in the attached document.

1. Set variables vTab6_on = 0 in the variable overview

2. Sheet properties -> Triggers Tab

a. On Active sheet set an action for external trigger for a Variable. Set vTab6_on = 1

b. On Leave sheet set an action for external trigger for a Variable . Select vTab6_on = 0

3. General sheet properties -> Tab color -> calculated base color = If($(vTab6_On)=1, rgb(255,79,79), rgb(255,255,255))

[Anonymous]

thanks!!!!!!!!!!!!!!!!!!!!!!!