Referencing a tab name

[mcwilson]

I want to have certain information disappear (white font) if the tab name is Project 1A.
When the tab name is changed, the font will change back.
I know this can be done with conditional formatting - if cell = x, then y.
but, i need to have a cell display the tab name and reference it when it changes. any ideas?

 

[baitmaster]

=RIGHT(CELL("filename",$A$1),LEN(CELL("filename",$A$1))-FIND("]",CELL("filename",$A$1)))

will return the sheet name, you can use this

 

[Jonmo1]

This will put the tabname in a cell.

=REPLACE(CELL("filename",A1),1,FIND("]",CELL("filename",A1)),"")

Note, this formula will only work after the file has been saved..
I.E. It will not work on a NEW book, untill that book is saved, then re-enter the formula.

Hope that helps.

 

[mcwilson]

sorry, still need help...

 

[mcwilson]

Okay still an issue....sorry. Apparently I cannot do the conditional formatiing bit. I want Rows B-Z to hide if A1 says "hide"
how do i do this with conditional formating?

Thanks

 

[baitmaster]

Use $ symbols to lock which cell is referenced in your conditional format

Or name the range. So call a cell "sheetName", then use this in your CF, instead of the cell refences you are currently using

 

[mcwilson]

sorry, still not following. So if i enter in hide in A1, i want all rows below it to be blanked out
anything else will show them as their normal color and font.
Can i do this by clicking on the conditional fomratinng tab?

 

[mcwilson]

nevermind, i got it. that was a noobe question.

thanks for your help!