How to make my Tab color change to Red when i selected the tab ?

[paulyeo11]

Hi All

my QV doc have the above feature, but only 8 out of 10 tab working , balance 2 not working.

i check my QV doc ,

step 1 . go to sheet properity

step 2. tab setting. custom color.

step 3. click on tab color .

step 4. base color , click on cal expression .

step 5. i found the expression = =if(vTab=3,vActiveBGColor)

I try the above 5 step for those 2 tab which is not working , but it does not work.

any thing i miss out ?

[Gysbert_Wassenaar · Accepted solution]

See attached example

[paulyeo11]

Hi Gysbert

I hv many tab. I unsble to use your example even it work fine. Becsuse only 2 tab is not working only . Now mine tab color by default is blue color . I not sure where to set it . Any hints ? And mine I need create var vTab =10.

[paulyeo11]

Hi Gysbert

finally i follow your example given me , and i realise that your approach is the best.

thank you

paul