Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello !
how can i force a color for an active sheet.
Thanks
May be, Condition for Sheet Properties like below =If(SubField(GetActiveSheetId(), '\', 2)='SH02', Green())
May be, Condition for Sheet Properties like below =If(SubField(GetActiveSheetId(), '\', 2)='SH02', Green())
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.