2 Replies Latest reply: Dec 1, 2014 5:30 AM by Peter Cammaert RSS

    Background color change on Sheet Activated

      How to change background color on Activation of Sheet

        • Re: Background color change on Sheet Activated
          Ruben Marin

          Hi, you can use a varible to do this, ie:

          create a variable vBgColor, you can assign a valur like: RGB(255,255,255)

          use this variable to assign the background color: $(vBgColor) or just =vBgColor


          In sheet properties create a trigger for activate sheet with an action, Type: external, Action: establish variable, then assign to the varibale vBgColor the color you want to change, ie: RGB(180,180,255)

          • Re: Background color change on Sheet Activated
            Peter Cammaert

            I'm not sure what you mean with "Activation of sheet"? If a sheet isn't activated, it's either completely invisible, or hidden by another sheet so that only the sheet tab is visible. In the first case, changing the background color is rather useless. In the second case, you can only change the tab color (see Sheet properties->General->Tab settings->custom colors).


            To change a tab color when a sheet is moved to the front, you can use a color expression like:


            =If(SubField(GetActiveSheetId(),'\',2) = 'SH01', white(), black())


            Don't forget to change the tab text color as well.