There is no such setting. You can set color statically.
But you can use Actions and a Macro to change the tab color dynamically.
There is an example in API Guide.qvw:
sp.TabAttr.BgColor.PrimaryCol.Col = RGB(255,0,0)
sp.TabAttr.FgColor.PrimaryCol.Col = RGB(0,255,0)
sp.TabAttr.Mode = 2 ' custom colors
You can change the color of the tab on the properties screen of the sheet. Select Custom Colors under Tab Settings. Click on Tab Color, select the Calculated option under Base color and use as expression:
Replace SH02 with the ID of the sheet you're changing the color setting. If you want you can use the same expression for the background color of the sheet so the entire sheet turns yellow if you select it.