Hiding Rows using conditions

[Guest]

Is it possible to hide a row based upon a value one of the columns?

Thank you.
Jeff R.

 

[Gord Dibben]

Jeff

You may get away with a filter, either auto or advanced to hide rows.

Or you may need VBA code, either event or menu/button driven.

Sub Hide_Rows()
'using set column A
Dim RngCol As Range
Dim i As Range
Set RngCol = Range("A1", Range("A" & Rows.Count). _
End(xlUp).Address)
For Each i In RngCol
If i.Value = "yours" Then _
i.EntireRow.Hidden = True
Next i
End Sub

In any case, if you're wondering, hiding a row is not a feature of Conditional
Formatting.


Gord Dibben Excel MVP

 

[Bob Phillips]

Only with VBA? Is that okay> If so, give some details.


--

HTH

RP
(remove nothere from the email address if mailing direct)