Hiding Rows using conditions
 

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

Thank you.
Jeff R.

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

On Mon, 15 Aug 2005 15:33:03 -0700, Looney
wrote:

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

Thank you.
Jeff R.

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


--

HTH

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


"Looney" wrote in message
...
Is it possible to hide a row based upon a value one of the columns?

Thank you.
Jeff R.