Conditional hiding / unhiding of rows ?

[JFL]

1.) I want to know whether there exists a possibility (other than with
macros) to hide or unhide with the help of a condition, as in:

if(C38="blab"; unhide(rows 38:52); keep them hidden)

Is that possible or is the conditional formating just limited to nice
colors of certain cells if they fulfill some kind of condition
regarding another cell?


2.) I want to know how I could insert in my worksheets, left to column
A, two columns 1 & 2 with a little "+" in order to display, when
clicking on it, the hidden rows? Does anyone understand what I mean? I
am not sure if I do?

Thanks for your help.

Best regards, JFL

 

[Frank Stone]

hi,
i am afraid that formating has little to do with hiding
and unhiding rows. sorry. i think you are stuck with a
macro. here is a macro i wrote for a guy to hide and
unhide a column. he had two measuremnts, english and
metric so he wanted to only see one at a time. the buttom
cations even changes. for your purposes, just change the
columns to your rows and it show work. trash the caption
changes.

Private Sub CommandButton1_Click()
'Sub machideshowcolumn()
If Columns("L:L").Hidden = True Then
Columns("K:K").Hidden = True
Columns("L:L").Hidden = False
CommandButton1.Caption = "inches"
Else
Columns("K:K").Hidden = False
Columns("L:L").Hidden = True
CommandButton1.Caption = "cms"
End If
hope it helps
Regards
Frank
End Sub

 

[Bob Phillips]

1) No CF, is format, not visibility, but you could use the grouping
levels -see 2

2) Look at Data>Group And Outline