Condition Formatting for Tabs
 

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?

Condition Formatting for Tabs
 

If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Gavin" wrote in message
...
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?