Change color for active sheet

[chadliagabsi]

Hello !

how can i force a color for an active sheet.

Thanks

[Anil_Babu_Samineni · Accepted solution]

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

[Peter_Cammaert]

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.