How do you set a condition format to a tab? For example, if you have
various formulas on one tab in a worksheet, if a formula triggers a
value that needs to be addressed in another tab, how can you set a
condition to automatically unhide that tab?

i.e. the tab will be hidden until the specified formula which is
conditioned triggers the appearance of this new tab.

Help?