Hiding Rows using conditions

L

Looney

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

Thank you.
Jeff R.
 
G

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
 
B

Bob Phillips

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


--

HTH

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