different color for Sheet's tab in activation and inactivation modes

[#1]

Hi,

I would like to show the sheet's tab in  two different colors while it is in activation and inactivation modes.

Is it possible..can anyone help me on this.

Regards,

Sankar

[sbaldwin · Accepted solution]

Hi, you could use a calculated dab colour using formulas like if('$(=GetActiveSheetId())' = 'Document\SH03',rgb(0,255,0)) for each sheet, eg attached.

Thanks

Steve

[johnw]

You don't need the dollar sign expansion, but yeah, that seems like the best way to handle it.

=if(GetActiveSheetId()='Document\SH01',rgb(0,255,0))

[#4]

Hi Steve,

Thanks for your answer. The solution is working fine.