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?